将数据库从sql server 2005转换为postgresSQL [英] convert database from sql server 2005 to postgresSQL

问题描述

嗨
我有一个使用Microsoft SQL Server 2005 Express Edition数据库的应用程序，现在数据库大小超过4GB.
因此，SQL Server现在不支持4GB以上的数据库. 我想将数据库从SQL Server2005更改为PostgreSQL.

那我该怎么做..
在我的整个代码中(例如Connection字符串，导入名称空间等，...

请帮助我..

Hi
I have one application which use the database of Microsoft SQL server 2005 Express Edition and database size now become more then 4GB.
So SQL Server not support More then 4GB database now,,,
I want to Change my DATABASE from SQL Server2005 to PostgreSQL.

So what steps can i follow ..
in my whole code (Like Connection string , importing namespace, etc,...

Pleas Help Me..

推荐答案

将数据从SQL Server传输到Postgres的一种方法是在数据库之间建立链接服务器，然后使用该服务器从SQL Server插入数据.给Postgre.有关更多信息，请参见: http://msdn.microsoft.com/en-us/library/ms188279.aspx [ ^ ]

另一件事是，SQL Server 2008 Express的大小限制为10GB，因此升级数据库引擎也将为您提供更多空间.请参阅: http://msdn.microsoft.com/en-us/library/cc645993.aspx [ ^ ]

One way to transfer data from SQL Server to Postgres is to cinfigure a linked server between the databases and use that to insert data from SQL Server to Postgre. More info, see: http://msdn.microsoft.com/en-us/library/ms188279.aspx[^]

Another thing is that SQL Server 2008 Express has a size limitation of 10GB so upgrading the database engine would also give you more space. Refer to: http://msdn.microsoft.com/en-us/library/cc645993.aspx[^]

浏览此链接，这可能对您有帮助
此处 [ ^ ]

go through this link, this may helps you
Here[^]

这篇关于将数据库从sql server 2005转换为postgresSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！