Is moving detach/attach, copying ldf/mdf reattact same as Upgrade/Migrate -- sql server (microsoft)

yanky
6/29/2006 12:35:31 PM

We have a SQL 2000 server. We want to get some of the databases over
to the new sql 2005 server. I have found many docs regarding 'moving'
databases from 2000 to 2005. Is this the same as
'Upgrading/Migrating'? I know there are issue with the DTS and
possibly the stored procedures. Do we loose anything(or is it the
same) when you move the 2000 databases versus Upgrade/Migrate?

Thanks,
yanky

KLDBA
7/4/2006 8:11:36 PM

I think it is migrating, all your object still maintain database
compatibility version 8.

~~~~
Paul
KL MAD DBA
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server (microsoft)

sql server (microsoft) : Is moving detach/attach, copying ldf/mdf reattact same as Upgrade/Migrate