Data Migration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data Migration

we are planning to migrate SQL Server 2000 data into SQL Server 2005. Right now its 45GB data. System is very critical. Is there any quick and fast way to migrate data? can I use Attach/deattach database utility to migrate data? is there any good online tutorial for microsoft? thanks for help Farrukh
Don’t you think running Upgrade advisor is best in this case to find the pre-cautionary errors for such data & code issues. http://www.microsoft.com/technet/community/events/sql2005/sql-10.mspx andhttp://sqlserver-qa.net/blogs/tools…-upgrades-of-your-sql-server-environment.aspx are related links. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
offcourse you can attache or dettache the database and also you export or import the database or you can get backup the database also restore the database on sql server 2005
before restore the database just convert the database compatabality level
go to the database property Amit Kumar
Mob.: 9873812005
Attach/Detach is the fastest (BU first of course) – but if the it is a "critical" database then factor in a db testing component in the database upgrade plan. Design a series of tests that replicate the type of use (queries & app) and relative usage based on your current SQL 2000 instance, on the new SQL 2005 instance. You don’t want to shoot yourself in the foot if your critical db app has problems with SQL, you don’t want to be the bloke responsible for losing a couple of hundred manhours because of a poorly planned db migration…
quote:Originally posted by farr77 we are planning to migrate SQL Server 2000 data into SQL Server 2005. Right now its 45GB data. System is very critical. Is there any quick and fast way to migrate data? can I use Attach/deattach database utility to migrate data? is there any good online tutorial for microsoft? thanks for help Farrukh

Backup restore is the best way to minimize the down time…. if you are using detach/attach method you have to wait until it copies 45 GB database file…
If you use backup restore…You can restore the full backup then apply the tlog backup…
stop the traffic on the source server and take the last tlog backup and apply the last tlog backup to the destination server and bring the new server online…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Nothing is easy unless you have practised it to the perfection and to avoid any sort of last minute surprises, even though it is a small database. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>