We have a client environment that has MSDE. We're looking to install SQL Server 2008 Express on the clients but must retain MSDE for other applications.
我们有一个MSDE的客户端环境。我们希望在客户端上安装SQL Server 2008 Express，但必须为其他应用程序保留MSDE。
Assuming both MSDE and SQL Server 2008 Express exist on a single machine what options are available to copy a database from MSDE to SQL Server 2008?
假设MSDE和SQL Server 2008 Express同时存在于一台机器上，那么可以使用哪些选项将数据库从MSDE复制到SQL Server 2008呢?
Suppose that MSDE may or may not be upgrade to SP4.
假设MSDE可能升级到SP4，也可能不升级。
Once moved the database can be removed from MSDE. It's a one-time move.
一旦移动数据库就可以从MSDE中删除。这是一个一次性的举动。
Thanks!
谢谢!
1 个解决方案
#1
4
Suppose that MSDE may or may not be upgrade to SP4.
假设MSDE可能升级到SP4，也可能不升级。
The SP4 requirement is only for in-place instance upgrade. For a side-by-side deployment and a detach-attach upgrade, SP4 is not required. All SQL 2000 SPs/RTM MSDE databases have the same physical format (v. 539, see this Q&A) so you can attach them to your SQL 2008 instance irrelevant of SP4 presence.
SP4要求仅适用于就地实例升级。对于并行部署和分离附加升级，SP4不是必需的。所有SQL 2000 SPs/RTM MSDE数据库都具有相同的物理格式(v. 539，请参阅这个Q&A)，因此您可以将它们附加到与SP4无关的SQL 2008实例上。
#1
4
Suppose that MSDE may or may not be upgrade to SP4.
假设MSDE可能升级到SP4，也可能不升级。
The SP4 requirement is only for in-place instance upgrade. For a side-by-side deployment and a detach-attach upgrade, SP4 is not required. All SQL 2000 SPs/RTM MSDE databases have the same physical format (v. 539, see this Q&A) so you can attach them to your SQL 2008 instance irrelevant of SP4 presence.
SP4要求仅适用于就地实例升级。对于并行部署和分离附加升级，SP4不是必需的。所有SQL 2000 SPs/RTM MSDE数据库都具有相同的物理格式(v. 539，请参阅这个Q&A)，因此您可以将它们附加到与SP4无关的SQL 2008实例上。