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.
| Author |
Topic |
|
SrivastavaDeepika
Starting Member
1 Post |
 Posted - 2015-04-28 : 08:21:29
|
| I tried to migrate from mssql server db to Postgres sql server using a converter tool, it works for only table migration .but i need to do migrate whole DB including tables, functions , stored procedures, views, sequences etc into postgres from mssql server. please help me .Thanks,Deepikadeepika |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-04-28 : 08:55:43
|
| You will need to do the programmable elements by hand. I am not aware of a universal tool that will translate them. Such a tool would need to be smarter than all of us, given the many differences between the two RDBMSes. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2015-04-28 : 17:08:13
|
| You can generate a script of all the objects etc. in a Microsoft SQL Database. You could then set about converting it until it will run, cleanly, on PostgresSQL. I've not used PostgresSQL much, but the differences were significant enough to give me a hard time! so I expect the migration will be a MAJOR project |
|
|
|
|
|
|
Postgres sql