Question by pwoodbine · Aug 21, 2018 at 03:16 PM · sql-server-2008 sql server 2008 sql-server-2016 data-import data-export

What is the best way to export data only (no structures or security logins) from a SQL Server 2008 server to an unlinked SQL Server 2016 server?

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?

0 Show 2

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM · Aug 22, 2018 at 12:33 PM 0

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?

pwoodbine JohnM · Aug 22, 2018 at 02:43 PM 0

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.