migrating from sql 2000 to sql 2005 on a different server
what is the easiest way.
I tried this..
stop servidesk
detach database from sql 2000
attach database on sql 2005
ran changedb.bat and changed from old sql to new sql server
last step is where it didn't work.. It reports back saying there is no sql server even though there are some databases already living on the new server.
Any ideas? Or am I doing this incorrectly
Thanks
I tried this..
stop servidesk
detach database from sql 2000
attach database on sql 2005
ran changedb.bat and changed from old sql to new sql server
last step is where it didn't work.. It reports back saying there is no sql server even though there are some databases already living on the new server.
Any ideas? Or am I doing this incorrectly
Thanks