CODEWITHSUNDEEP
sql-serverpostgresql
MAK
MAK

Reputation: 7260

Stored Procedure from SQL Server to PostgreSQL

Is there any tool to convert Microsoft SQL Server 2008 r2 Stored Procedure to PostgreSQL Function?

OR

Need to convert manually by developer?

I came up with pretty Old Post regarding the same.

Upvotes: 1

Views: 2331

Answers (1)

tukan
tukan

Reputation: 17345

Is there any tool to convert Microsoft SQL Server 2008 r2 Stored Procedure to PostgreSQL Function? OR Need to convert manually by developer?

To cut long story short, you need a developer to convert them.

If in theory such tool existed, it would be extremely complex (who would need it that badly to pay for it? The hire a developer to convert them is cheaper). Such application would need to be adjusted (imagine nearly the whole development cycle) for any version changes in both MSSQL and postgres.

If we are talking data then it is different story: For MSSQL server you can check this section - http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_SQL_Server

There is a tool called fullconvert which is able to migrate data

Upvotes: 1

Related Questions