I have tried to search and can not find anything to tell me how to do it. I have databases in SQL 2008 and SQL 2012. I need to generate Bacpac files so that they can be imported and restored in Azure.
When I try to do it with SQL Manager I get the error:
Is there any way to do it with SQL Manager or Visual Studio?
Thanks in advance
While you can do it directly in the SQL Management Studio, I use it within a database project in Visual Studio 2015 You must install the latest version of
(or you can find the version for VS that you have) There you will be able to create one from scratch, or import an existing DB. Then you can publish the DB and generate the .bacpac file, you can even publish directly to Azure;)
You can have more information
The good thing ... that you can manage the changes, compare the DB to only upload the changes you have, be able to import or export these changes (bring changes that are in the server), even compare not only the artifact scheme ( tables, procedures, functions, etc.) but also comparison of data.
PS: Take a look if you can to VS2017 have a new way of managing Database projects, with RedGate tools