question

vrhari avatar image
vrhari asked

Migrate sql2000 db to sql2008 db

I have a db in sql 2000, which has few tables with dbo as owner and few tables with a dbuser as owner. Now i want to migrate this db to new db in sql 2008 with dbo as owner. pl help. thanks
sql2008sql2000
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
The easiest way to do the upgrade is to backup the SQL Server 2000 database and then restore it to SQL Server 2008. You then just have to change the compatibility level and update the statistics. After the upgrade, you can change the owner on your objects to DBO. You could change the ownership before you backup too. Either way, that ownership change shouldn't be a part of the upgrade. You just have to use the [ALTER SCHEMA][1] command for that. [1]: http://technet.microsoft.com/en-us/library/ms173423(v=sql.100).aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.