port from postgresql to ms sql srvr 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

port from postgresql to ms sql srvr 2005

hi What is the best method to port my database from postgreSQL to Ms SQL Server 2005? I have a dozen of sql scripts to create and configure all tables in postgreSQL. Should I update all scripts manually, to be executable on ms sql server 2005?
Or do you know faster methods?
(i know it exists, but boss doesn’t allow me to buy a convert-tool). thx
I don’t think there any way other than doing it manually…
You can make use of SSIS packages to copy the data but you may need to convert the scripts manually… Check some cheap tools…
http://esf-database-convert.easyfrom-inc.qarchive.org/ http://www.informit.com/articles/article.asp?p=409471&rl=1
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Refer to http://www.postgresql.org/docs/techdocs.29 tool. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.