Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 conversion

Author  Topic 

my_aro
Yak Posting Veteran

50 Posts

Posted - 2005-11-25 : 00:19:31
is it possible to convert databases from ms sql server to postGres?

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-25 : 01:11:08
Do you want to create new Db at postGres as that of SQL Server or copy the data from SQL Server to postGres?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

my_aro
Yak Posting Veteran

50 Posts

Posted - 2005-11-25 : 01:13:15
i wanna copy the data from sql server to postGres but if its possible can i use those files of sql server for posGres?
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-25 : 01:24:42
In Enterprise Manager use Export wizard to copy data to postGres

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

my_aro
Yak Posting Veteran

50 Posts

Posted - 2005-11-25 : 01:41:42
ok thanks.. so what about if i use the databassse files? is it possible?
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-25 : 02:03:00
I think you cant use Database files
If you have data in EXCEL then you can import data in Postgres using EXCEL file

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

my_aro
Yak Posting Veteran

50 Posts

Posted - 2005-11-25 : 02:17:44
but can i import mssql files into excel?
Go to Top of Page

my_aro
Yak Posting Veteran

50 Posts

Posted - 2005-11-25 : 02:18:13
data i mean
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-25 : 02:23:24
Yes
1 DTS
2 Export Wizard
3 OpenRowSet http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

my_aro
Yak Posting Veteran

50 Posts

Posted - 2005-11-25 : 02:29:01
ow well.. thanks so much!
Go to Top of Page
   

- Advertisement -