Friday, March 9, 2012

How to create a copy of SQL Server 2000 database in SQL Server 2005 Express?

I have a database called 'DB1' in SQL Server 2000. I want to create the same database in SQL Server 2005 Express including the original data in tables.

How would I do that? I cannot find any option to do this upgrade in SQL Server Management Studio.

Check out this:

How to: Upgrade to SQL Server 2005 with the Copy Database Wizard

|||

The article you mentioned does not apply to the 2005 Express Edition. The Management Studio for the Express Edition contains no Copy database option that the above article mentions.

I think there is NO tool for doing this upgrade for Express Edition of SQL: Server 2005.

|||

Hi,

Just want to create a copy of SQL Server 2000 database in 2005 ? Why don't you backup you database in SQL Server 2000 and restore it in SQL Server 2005.

Thanks.

|||

Hi,

As mentioned above you can backup ur database and then restore it in SQL 2005.

PLease have a look at this article which explains the steps for backup and restore:

http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups

Please let me know if you have any queries.

No comments:

Post a Comment