When doing that generate scripts on the database level what difference does it do from doing a backup and restore on the database? It seems to me that they both provide the same purpose. What would be best to use between the two? Is one better than the other? I am migrating database from one domain to another and both are different domain but have sql server 2012


With backup you have all data. Of course you can generate script for data, but for a DB with 1-2 GB the script will be very big and will execute long time.

The best way in my point of view is detach/attach method. It will preserve the current state of the DB. Of course you can make backup before that. In that case you also have to take into account downtime for transferring database between servers.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.