如何将sql2000的数据库附加到sql2008 [英] how attach a database of sql2000 to sql2008

问题描述

如何将数据库从SqlServer 2000附加到SqlServer 2008 ????:confused:

推荐答案

1.使用SQL Server 2008内置的数据库还原功能.

2.在SQL脚本中使用RESTORE命令来执行它.
还原(Transact-SQL) [

1. Use SQL Server 2008 , database restore functionality that is in-built.

2. Use RESTORE command in SQL scripts to perform it.
RESTORE (Transact-SQL)[^]

就像其他人所说的很明显，您没有费心尝试.一件事，一旦执行此操作，您将无法回到SS2000.

As someone else said, it''s obvious you had not bothered to try. One thing, once you do this, you won''t be able to move back to SS2000.

另一种简单的方法是....

在sqlserver 2000中备份当前数据库，


在sqlserver 2008中创建具有相同名称的数据库

现在使用选项覆盖现有数据库来还原sqlserver 2008中的数据库

或从2000分离数据库并将其附加到sqlserver2008

Another Simple way is....

In sqlserver 2000 take backup of the current database,


create database with same name in sqlserver 2008

now restore the database in sqlserver 2008 with option overwrite the existing database

or detach the database from 2000 and attach it in sqlserver2008

这篇关于如何将sql2000的数据库附加到sql2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！