July 11, 2016 at 8:30 am
I need to migrate a small database from 00 to 08 - also across domains. I've reviewed users and permissions and intend to create these anew on 08.
I've tried copy database but it fails, since some of the users on 00 (the old domain) don't exist in the new domain. I don't want them to exist.
What's the best way of migrating without taking users?
Thank you.
July 11, 2016 at 8:35 am
Backup, restore, change compatibility level to 100, remove old users, create new ones.
John
July 11, 2016 at 8:48 am
ok, thanks John.
July 12, 2016 at 5:08 am
wow thats great, I didn't expect it to be that straight forward approach.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply