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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-11-07 : 07:27:55
|
| shubha writes "hi..i want to migrate sql server 2000 database to sql server 2005 database.Is there any tool other than Upgrade advisor?Any non microsoft tool is there for migration?" |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-11-07 : 08:21:44
|
| What's wrong with the microsoft one? Can't think of a reason why anyone elso would create such a thing...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-07 : 08:46:54
|
| "i want to migrate sql server 2000 database to sql server 2005 database."Is there some reason not to just "restore" a backup of the SQL 2000 database onto the SQL 2005 server?Kristen |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-11-07 : 08:58:39
|
quote:
Is there some reason not to just "restore" a backup of the SQL 2000 database onto the SQL 2005 server?
Have you tried this Kristen? I have not done any upgrades myself yet but there are a few of compatibility issues and I would do some vigorous testing before using this approach...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-07 : 09:16:49
|
| "there are a few of compatibility issues"Indeed, there definitely are. I probably misunderstood the question in that its easy to get a database from SQL 2000 to SQL 2005 - doesn't mean that the original coding is going to be compatible with SQL 2005 of course, thanks for pointing that out.Kristen |
|
|
|
mightypenny_ph
Yak Posting Veteran
54 Posts |
Posted - 2006-11-08 : 21:51:32
|
| why don't just use the simple restore statement... SQL Server 2005 will do all the upgrading stuff for you... we've tried it here and it is definitely working pretty well... create a backup file from 2000 then restore it in 2005.. messages will also be displayed...SlayerS_`BoxeR` + [ReD]NaDa |
|
|
|
|
|
|
sql server 2000 database migration