如何在 SQL Server 2008 Express 中打开 SQL Server 2000 数据库？
一位朋友最近要求我帮助他更改一个应用程序，以允许多个实例连接到同一后端数据库。然而，他对应用程序或一般CS的内部工作了解非常有限，而且为他开发应用程序的人已经离开了。
我的猜测是，可以通过对应用程序的数据库连接属性进行一些简单的更改来完成此任务。问题是我不知道数据库是如何设置的。前一位开发人员留下的注释提到数据库是在 SQL Server 2000 中创建的。不过我没有 SQL Server 2000。是否可以打开/迁移 SQL Server 2000 数据库到 SQL Server 2008 Express，如果可以，我该怎么做？如果没有，数据库迁移的合理方法是什么？
非常感谢您的帮助！
——钓鱼者Y.
A friend recently asked me to help him to change an application to allow multiple instances connecting to the same back end database. However, he has very limited understanding toward the inner work of the application or CS in general, and the guy who had developed the application for him has left.
My guess is that it is possible to get it done by making some simple changes to the application's database connection properties. The problem is that I have no idea how the database was set up. A note left by the previous developer mentioned that the database was created in SQL Server 2000. I do not have SQL Server 2000 around though. Is it possible at all to open/migrate the SQL Server 2000 database to SQL Server 2008 Express, and if so, how can I do it? If not, what the reasonable approach for the DB migration?
Thanks a lot for your help!
--Angler Y.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
是的，您可以使用简单的分离附加方法或备份恢复方法来迁移数据库
但是，
如果数据库大小超过 4 Gb，则它将无法在 Sql Express 2008 上运行
Yes, you can migrate the database using simple detach-attach method or backup-restore method
BUT
if the database size exceeds 4 Gb it woun't work on Sql Express 2008