We are currently in a self-administered Web / SQL Server environment using SQL Server 2008 and we are about to switch to having external DBAs who utilize SQL Server 2016. These servers are not linked. What is the best way to export our data without the table structures and overwriting the security logins when it is imported into their environment? I don't think we can use bcp due to permissions. What are our options?
Why can't you just send them a backup of the database and they restore it? Wouldn't you want the table structures to be the same upon a migration?
Forgive me, I'm a SQL novice, but I think the main thing is we don't want the security logins to be overwritten upon restore. Also from what I understand, the external DBAs don't want to do the work of deleting users/logins. Their local users will be set up differently from our development instance. It should basically be a script/file we hand over to them with the data on a one-time migration.
21 People are following this question.
