Geek Answers Handbook

Export SQL Database Database Project

Some kind of web application has been sent to me to see if I can give them a hand with re-placement. I did not work with database projects in Visual Studio, and it looks like this application uses a database project in Visual Studio, I see how to export it as an SQL script, so I can add it to the SQL server management studio, I read, what can I do this by going to the properties of the database project and clicking the "expand" tab, however I do not have a deployment tab! I guess it before the version of Visual Studio. I am using 2010. How to export a project as an SQL script file?

enter image description here

+4
source share
1 answer

The following steps may be helpful:

You can try the settings tab. The environment depends on the type of database design. In one of my projects, I have the tab "Project Settings", where it gives me the opportunity to create an SQL script (see the figure below) enter image description here

Or in other editions of Visual Studios
1. Open the project / solution and right-click the project and select "Properties" or double-click the "Properties" folder
2. A new window appears in your environment indicating all the properties of the project. Now go to the maximize tab
3. In the "Deployment Action" section, select "Create Deployment Script (.sql)" from the drop-down list.
4. Click the save button and close this window.
5. From the Build menu, select Create Solution, and then select Expand [Solution Name]
6. After the script is deployed, it should be available in the SQL-debug folder,
for example: [path to my project] \ sql \ debug \ script.sql

+5
source

More articles:


All Articles