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