Convert scripts for Postgresql to SQL Server

Not Active

I have a project to convert a database from Postgresql to SQL Server. I know of tools to convert the database from one to the other but all I have are scripts right now. Does anyone know of a utility that can take scripts created for Postgresql and create a SQL Server database from them?

only two letters away from being an asset

Mycroft Holmes

Depending on the size of the database it would almost be worth installing postgre just to use the conversion tools. I'm assuming they have an express type product.

Never underestimate the power of human stupidity RAH

Not Active

There is no express version but I already have Postgresql installed. The problem in the scripts I've been provided with won't run. I wanted to try converting them to TSQL and running them against SQL Server directly since the ultimate goal is to port it to SQL Server anyway.

only two letters away from being an asset

Mycroft Holmes

Sounds like a hand job to me :laugh: That my double entendre for today.... I'd try splitting the scripts to types ie tables, procs and views, see if there are any standard conversions and try running them individually. Sounds like a LOT of work even if there are no constraints and key involved. I'd go back to the client and try and get a backup.

Never underestimate the power of human stupidity RAH

Not Active

:laugh: :laugh: :laugh:

Mycroft Holmes wrote:

I'd go back to the client and try and get a backup.

Trying. Unfortunately, I've taken over this project after the original team's failure. They are uncooperative to the point of potential legal actions by the client. I had the suspicion that it would a tedious manual process but had ask just in case.

only two letters away from being an asset

Tim Carmichael

As others have said, this is going to be a tedious manual process. I work with Ingres and SQLServer on almost a daily basis; Ingres isn't PostreSQL, but I'm assuming it isn't too far off either. If you have the scripts to create tables, etc, can you write a script to extract the table name, columns, datatypes and null settings? Having these, you should then be able to script the tables creation in SQLServer. I will help as I can. Tim