I have developed a SQL Server 2000 Database on my development system. I need to copy the Database to my client's Server. Unfortunately they are not linked.
What is the best way to copy the Database? Can I detach it on my Server, make a copy of the file. Copy the file to my Client's Server, and then Attach it?
OR IS THERE A BETTER WAY?
Thanks in advance for your helpDetach, copy, reattach is probably the fastest way to copy a database to another box, although there are plenty of other choices. Using BACKUP / RESTORE is probably the safest, and it doesn't take much longer than detach/copy/reattach does.
-PatP|||the best way (In My Opinion)
is to perform a transfer database task in dts
it copies everything without having to require a detach then copy then attach.
backing up and restoring is comprehensive but takes a while to perform
and the objects are in whatever state they were in when you backed em up
transfering the db is fast and you get brand new objects so for example indexes are created new so they are not fragged..
[Books Online] DTS tasks, transferring database objects
No comments:
Post a Comment