July 13, 2007 at 4:50 am
We are doing a migration from Sql2k to sql2k5.
I am proposing moving the data by means of distributed queries.
Pros and cons?
Do you have another opinion?
July 13, 2007 at 5:26 am
Why not import export. Why not backup the database and restore the database and change the compatibility level to 90 to have sql 2005 features.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 13, 2007 at 10:13 am
Why not just move the physical files? detach, move, attach - the bulk of the time is spend in moving the files, not in the admin aspect.
July 16, 2007 at 2:22 am
You can choose a better option but remember to move the logins. jobs, etc they are important too.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply