且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

sql开发人员到企业版

更新时间:2023-01-22 18:50:20

Google是您的朋友:很好,经常拜访他.与在这里发布问题相比,他可以更快地回答问题.

快速搜索使其成为热门搜索: MSDN:升级到SQL Server 2005 [ ^ ]

将来,请尝试至少自己进行基础研究,不要浪费您或我们的时间.
Google is your friend: Be nice and visit him often. He can answer questions a lot more quickly than posting them here...

A very quick search gave this as the top hit: MSDN: Upgrading to SQL Server 2005[^]

In future, please try to do at least basic research yourself, and not waste your time or ours.


替代方法1:在Developer Edition上进行完整的数据库备份,将备份文件复制到另一台服务器,然后将其还原.

替代方案2:分离数据库,将MDF和LDF文件复制到服务器,然后将数据库附加到该新服务器上.
替代方案3:您可以使用一些第三方工具(我使用的是EMS SQL Server Manager)来创建数据库脚本.您可以在开发人员服务器上运行脚本,将脚本带到企业中,然后在此处运行.

hth,
foxyland
Alternative 1: Make a full database backup on the Developer Edition, copy the backup file to the other server, and restore it there.

Alternative 2: Detach the database, copy the MDF and LDF file to the server, and then attach the database on that new server.

Alternative 3: You can create a database script with some 3rd party tools (one that I use is EMS SQL Server Manager). You can run the script on the developer server, take the script to the enterprise, and run it there.

hth,
foxyland