how to create bacpac file from SQl and import into other Dev VM

(0) Share

Report

Posted on by Dhanshri

515

Hi All,

I want to move data from one Development (sandbox) instance to another. From Prod to sandbox it is done in easy way but if we want to move data base between sandbox instances then how we can export db as bacpac file from one VM and import it into another VM?

Thanks,

Shri

I have the same question (0)

All responses (19)

Answers (2)

Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report

Have you already looked at docs.microsoft.com/.../export-database

Was this reply helpful? Yes No
Dhanshri 515 on at

Like (0)

Report

Thanks for quick reply :)

For my Develop & Test Box instance "Move Database" option is not available under Mainatin tab.

Thanks,

Shri

Was this reply helpful? Yes No
Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report

If these are dev environments, you won't see this option on these. You can RDP into these boxes and export the database and then copy the file to other box and import the database there.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

just export SQL DB from one dev box and import in other one

can click on SQL DB, actions and import and export options

Was this reply helpful? Yes No
Dhanshri 515 on at

Like (0)

Report

But it will create .BAk file right? In D365 we need bacpac file for DB refresh, please correct me if my understanding is wrong?

If we restore db in similar old way just we used to do in Ax 2012 will it overwrite the code / objects?

Thanks,

Shri

Was this reply helpful? Yes No
Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report

Code doesn’t exist in database anymore in D365. Code is in file system so it won’t overwrite code. You can take backup and restore like any other database from SQL

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (0)

Report

Tier 1 boxes use SQL Server. You can create a bak file via SQL backup and restore it on another Tier 1. Tier 2 or higher use Azure SQL, to import data into Azure SQL you need a bacpac. It can be exported from Tier 1. Bacpac can be also imported to Tier 1 if required.

Code is not stored in DB and to move source code you use version control or model files.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Bacpac is a format used by Azure SQL. Bak is a format used by SQL server. If you want to copy data between dev boxes, use .bak. It's a lot faster, too.

The application code is not stored in the database.

Was this reply helpful? Yes No
Anup Shah MSFT on at

Like (0)

Report

Please click "Yes" if your question has been answered. Thanks

Was this reply helpful? Yes No
Dhanshri 515 on at

Like (0)

Report

Hi Nikolaos,

both are development & build type sandbox environment.So you think .Bak file will work?

Thanks,

Shri

Was this reply helpful? Yes No