SQL Server Database Project - Scripting Change
We started using a SQL Server Database project in Visual Studio 2012 by attaching an existing database. We are developing a web application that connects to this database.
We now have about twenty stored procedures updated for the next version. How do I create a script file containing only updated stored procedures? We need to send this script to our clients along with the web application executables.
Is there any function that allows us to compare and generate only modified scripts?
Thanks in advance!
+3
source to share
1 answer
Use Schema Compare like this:
- Create a schema comparison that compares a database design to one of the production databases.
- Run schema comparison.
- Exclude everything except stored procedures (plus any objects they depend on).
- Click "Create" Script.
If you save this schema comparison, you can reuse it the next time you need to post more changes to the stored procedure.
+3
source to share