Обсуждение: BUG #4719: Convertion of Data from MSSQL to Postgres

Поиск
Список
Период
Сортировка

BUG #4719: Convertion of Data from MSSQL to Postgres

От
"Nagendra.K"
Дата:
The following bug has been logged online:

Bug reference:      4719
Logged by:          Nagendra.K
Email address:      nagendra.ind24@gmail.com
PostgreSQL version: Pls Adv Srv 8.3
Operating system:   WinXP SP2
Description:        Convertion of Data from MSSQL to Postgres
Details:

I had created data in MSSQL server and i want to convert the data into
PostgreSQL. I converted the data into Postgres using DBConvert(converter).As
the converted data is in my system, i want to make my system as a server.
And the same version of Postgres was installed in another system. Inorder to
transfer data from my system into the remote system.Is there any tool to
connect my system(server) by the another system and transfer the data. Will
u please say me the configuration where i have to change.
Thanks & Regards,
Nagendra.K

Re: BUG #4719: Convertion of Data from MSSQL to Postgres

От
Heikki Linnakangas
Дата:
Nagendra.K wrote:
> PostgreSQL version: Pls Adv Srv 8.3

Is this the EnterpriseDB's commercial Advanced Server product? If so,
please contact EnterpriseDB technical support. This mailing list / web
form is for reporting bugs in the community PostgreSQL.

> I had created data in MSSQL server and i want to convert the data into
> PostgreSQL. I converted the data into Postgres using DBConvert(converter).As
> the converted data is in my system, i want to make my system as a server.
> And the same version of Postgres was installed in another system. Inorder to
> transfer data from my system into the remote system.Is there any tool to
> connect my system(server) by the another system and transfer the data.

I have no idea how DBConvert works, but it sounds like you have some
data in a file or files in your filesystem, and you need help to load it
into PostgreSQL. How to do that depends on the format DBConvert
converted it into.

Looking at DBConvert's website, though, it seems that it support some
kind of direct synchronization between two databases. Perhaps you should
study DBConvert in more detail and learn how to use that. Or contact
DBConvert's support if you run into problems with that.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com