patternsqlMinor
migrating tables from Postgres to SQL Server 2008
Viewed 0 times
tables2008postgressqlmigratingserverfrom
Problem
(I fear what I wish to accomplish shall not be easy, but a lot of my googling around about it yielded rather dated results, so here it goes...)
I have a Postgres 8.4.x database with over 100 tables. I need to recreate these tables in SQL Server 2008. I'm not concerned about the data, just the structure.
Are there any slick tools, shortcuts or suggestions to accomplish this? Heck, I'll even take the find-and-replace values to run on Postgres CREATE TABLE scripts!
Thanks!
I have a Postgres 8.4.x database with over 100 tables. I need to recreate these tables in SQL Server 2008. I'm not concerned about the data, just the structure.
Are there any slick tools, shortcuts or suggestions to accomplish this? Heck, I'll even take the find-and-replace values to run on Postgres CREATE TABLE scripts!
Thanks!
Solution
We found a solution for this that ended up being super-fast: using a wizard in our ETL tool Pentaho Data Integration (Kettle). Open a new job then Tools -> Wizard -> Copy Tables. I wouldn't be surprised if other ETL tools had similar wizards.
Context
StackExchange Database Administrators Q#15817, answer score: 3
Revisions (0)
No revisions yet.