question

pwoodbine avatar image
pwoodbine asked

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?

sql-server-2008sql-server-2016sql server 2008data-importdata-export
2 comments
10 |1200

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

JohnM avatar image JohnM commented ·

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?

0 Likes 0 ·
pwoodbine avatar image pwoodbine JohnM commented ·

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.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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