snippetMinor
How to Export SQL Server Database To A File For Later Import To Different Computer
Viewed 0 times
filelatersqldatabasedifferentexportforhowservercomputer
Problem
I'm using the Sql Server 2012 Import and Export data (64) i'm not sure what options i should be picking to do what i want. I just want to be able to export all the data in the database to a file which i can then send to my other machine and then import the database.
The databases just contains tables.
The databases just contains tables.
Solution
I upvoted the comment by @Alex K. as this, I believe, is the easiest way of accomplish what you want. Backup the database, when asked copy the .bak file where you think is better for your needs, maybe even you can copy it already in a place where the other PC has access. Then do the opposite on the other SQL Server instance on the other PC, restore the database from the .bak previously saved.
Here is a link to a detailed description on how to backup the database using SSMS.
And here how to restore using the SSMS.
Here is a link to a detailed description on how to backup the database using SSMS.
And here how to restore using the SSMS.
Context
StackExchange Database Administrators Q#24687, answer score: 6
Revisions (0)
No revisions yet.