May 13, 2014 at 11:09 am
Hello all,
I am a MID to SENIOR developer, but I have limited expertise in migrating data. Could someone point me in the right direction please? Seems like the following is the best practices though...
1) Script out DB from source, create DB on destination server, and run scripts (roles, tables, constraints, etc).
2) Use INSERT statements to populate tables or SSIS packages to import data.
1a) I could simply restore the DB's from a backup, but if I remember correctly, you still have to run scripts to add roles, constraints, etc that would need to be scripted but this seems like a more efficient way.
2b) Attach and detach the DB's from source to destination. In my opinion this is risky and perhaps not an option for production systems.
Thanks in advance!
Dave
Everyone has a plan until they get punched in the mouth. --Mike Tyson
May 13, 2014 at 1:35 pm
I'd either restore from backup or detach attach.
Yes, would like have some orphaned users (no matching login) you'd have to fix, but roles and permissions would carry over because they are DB specific.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 13, 2014 at 1:48 pm
Thanks Jack.
I thought I was over-thinking a little.
Everyone has a plan until they get punched in the mouth. --Mike Tyson
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply