Export SQL Server Database 2014

0

I need to export the SQL Server database to send to a friend.

But I'm not getting it, I wanted to know if I copy these files and send them to him, if it will work on his SQL Server (I do not know what version of it).

C: \ Program Files \ Microsoft SQL Server \ MSSQL12.SQLEXPRESS \ MSSQL \ DATA \ myBD.mdf C: \ Program Files \ Microsoft SQL Server \ MSSQL12.SQLEXPRESS \ MSSQL \ DATA \ myBD_log.ldf

Is this the right way to export the Database or what is the right way?

    
asked by anonymous 07.10.2015 / 04:28

2 answers

5

Good Carlos,

It's important to know what version of it. You can copy these yes files and send them to it, but you need to stop the SQL Server service first.

You can also do a Backup and send it to it.

Or you can use the more convenient: the export function of Management Studio: Right-click on the Database > Tasks > Export Data-Tier Application, it exports the Database to a BACPAC-format file and your friend should look like this: Right-Click on DATABASES > Import Data-Tier Application. And I personally advise you to use the latter method.

    
07.10.2015 / 11:52
0

Good afternoon Carlos,

First, without knowing the destination SQL version, you may end up sending the database and even though it is not possible to import the database. To know the version of the target SQL and yours too and see use the program below: link In it you can see the version in the SQL tab > Version. You'll also be able to see lots of other information.

Once this is done, see if your version is less than or equal to it, if it is to make a backup that is safer.

    
26.10.2016 / 20:29