SQLDBAgeeks
Contact Us
Home
Contact
Services
Showing posts with label
MS sql migration move
.
Show all posts
Showing posts with label
MS sql migration move
.
Show all posts
Tuesday, March 15, 2011
How to migrate databases from MS sql 2000 to MS SQL 2005/2008
There are 4 ways to migrate databases from one server to another:
backup bak files and restore to new server
copy the mdf and ldf files to new server and attached the databases to new server
use the migration wizard to move the objects and databases over
script the entire restore process and run in sqlcmd
Older Posts
Home
Subscribe to:
Posts (Atom)