Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rp
Starting Member
3 Posts |
 Posted - 2007-10-25 : 12:15:49
|
| Hi all,I need to Migrate all databases from SQL 6.5(WinNT) to SQL 2005 (Win2003). I have the files in .DMP format and we are running 6.5 live right now.I've seen links on how to upgrade from 6.5 to 2000 and a different link on how to upgrade from 2000 to 2005 but do any of you know how to upgrade from 6.5 to 2005 without dealing with SQL 2000?If there is any way of upgrading from SQL 6.5 to SQL 2005 then please let me know.Thanks______________rp |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 12:20:53
|
| You can't go directly from 6.5 to 2005 unless you write your own utility with say bcp/DTS/SSIS.If you aren't willing to reinvent the wheel by creating your own upgrade utility, then you must upgrade to 2000 first then to 2005. Also, you can't use those dmp files to go to 2000 anyway. There is no backup/restore or detach/attach method when going from 6.5 to 7.0 or 6.5 to 2000. You must use the upgrade wizard to do it.Welcome to the 2000s.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rp
Starting Member
3 Posts |
Posted - 2007-10-25 : 13:12:10
|
| Thanks for the quick reply tkizer.The databases themselves are not that big. Is there any way to manually migrate it (if at all possible <-- not that I like to do it...) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 13:13:44
|
| Yes. But it will require a lot of work on your part. Are you familiar with bcp?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rp
Starting Member
3 Posts |
Posted - 2007-10-25 : 13:30:10
|
| no idea... I am still not sure how everything is setup in this location. This is my 3rd day in this (new) job.Ive decided that I will setup a SQL2000 server in another machine, migrate using the wizard and then migrate it back to the SQL2005.These are the links from where I found info on how to do them (might help others looking for a similar solution)SQL 6.5 -> SQL 2000http://msdn2.microsoft.com/en-us/library/aa197948(SQL.80).aspxorhttp://msdn2.microsoft.com/en-us/library/aa197948(SQL.80).aspxSQL 2000 -> SQL 2005http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/I haven't tried them yet, so if you find these links to be either inaccurate or know of a better source then please do post it here.Thanks again. |
|
|
|
|
|
|
Migrate Database from SQL 6.5 to SQL 2005