从SQL Server到PostgreSQL的存储过程

时间:2022-07-20 09:37:16

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

有没有工具将Microsoft SQL Server 2008 r2存储过程转换为PostgreSQL函数?

OR

Need to convert manually by developer?

需要由开发人员手动转换?

I came up with pretty Old Post regarding the same.

我想出了相同的漂亮老邮政。

1 个解决方案

#1


1  

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

有没有工具将Microsoft SQL Server 2008 r2存储过程转换为PostgreSQL函数?或需要由开发人员手动转换?

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.

如果理论上存在这样的工具,那将是非常复杂的(谁需要付出代价呢?雇用开发人员转换它们会更便宜)。对于MSSQL和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

如果我们正在讨论数据,那么它就是不同的故事:对于MSSQL服务器,您可以查看此部分 - 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

有一个名为fullconvert的工具可以迁移数据

#1


1  

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

有没有工具将Microsoft SQL Server 2008 r2存储过程转换为PostgreSQL函数?或需要由开发人员手动转换?

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.

如果理论上存在这样的工具,那将是非常复杂的(谁需要付出代价呢?雇用开发人员转换它们会更便宜)。对于MSSQL和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

如果我们正在讨论数据,那么它就是不同的故事:对于MSSQL服务器,您可以查看此部分 - 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

有一个名为fullconvert的工具可以迁移数据