0
I need to export the SQL Server database to send to a friend.
However I am not getting, I wonder if I copy these files and send to it, if it will work in his SQL Server (I do not know what version of it).
C: Program Files Microsoft SQL Server MSSQL12.SQLEXPRESS MSSQL DATA meuBD.mdf C: Program Files Microsoft SQL Server MSSQL12.SQLEXPRESS MSSQL DATA meuBD_log.ldf
This is the right way to export the database or the right way ?
5
Boas Carlos,
It is important to know what version of it is. You can copy these files and send them to it, but it is necessary to stop the SQL Server service.
You can also make a Backup and send it to him.
Or you can use the most convenient: the export function of Management Studio: Right-click on the Database > Tasks > Export Data-Tier Application, it exports the Database to a file with BACPAC format and your friend should: Right-Click on DATABASES > Import Data-Tier Application. And I personally advise you to use this latter method.
0
Good afternoon Carlos,
First without knowing the version of the target SQL you may end up sending the database and even then it is not possible to import that database. To know the version of the target SQL and yours also and see use the program below: https://sourceforge.net/projects/dba-program/ In it you can see the version in the SQL tab > Version. In addition you will be able to see many other information.
Once this is done, see if your version is equal to or lower than his, if you are going to make a backup that is more secure.
Browser other questions tagged sql database sql-server
You are not signed in. Login or sign up in order to post.
vlw for the answer
– Carlos Ferreira