SQL: Moving database(s) from Server to Server

~J~

~J~

~J~

Soldato
Joined
20 Oct 2003
Posts
7,558
Location
London
Just wanted to double check something as I've only ever done this YEARS ago!

Currently got about 20 databases on a SQL2000 server which I'm copying (using the object method, NOT the Detach/Attach method) to a newer SQL2005 server.

Will the indentifiers of all records be preserved or are there some precautions to take?
 
all the data should be ok. But there is one method of doing it that messes up the identity specifications and primary key assignments (can't remember which one sorry!). So I'd move one or two tables and check 'em out.

akakjs
 
You must log in or register to reply here.
Back
Top Bottom