Tool to save script in sql as you develop to go into production

Question

Tool to save script in sql as you develop to go into production

Navigation

#1 by (1 votes)

0

There is some tool to store the scripts of stores proc (not only stors, they can be functions, tables, trigers, etc.) what are you creating in development? So that in the end when you finish developing you can go to production. without the need to be looking the script or being saved in another separate file (I am currently working in this way but sometimes I forget). Thanks

sql-server

asked by Feder 27.03.2018 в 22:31

source

1 answer

Different PHP versions in Server Read upper triangle of a matrix and print it on the screen

score 1 · Answer 1

In SQL Server 2008 R2 you can use the same program to generate such scripts when you need them, either all at once or individually.

Individual You search for the object in the object browser, right click and generate the script you need.

Collective You search for the database from which you want to obtain the scripts you need, Tasks , Generate scripts ... .

In it, an assistant will open to help you select the objects you need, such as tables, store procedures or views.

Once you select the objects you need on the next screen, you select how you want to store them, in a script saving it or in a screen script.

Note: One of the remarkable things that this option has to use is that if you need to generate a script with both structure and data (or only one of them) you should specify in the Advanced options .

I hope these options help you to be able to save your scripts, as this is only to organize your repo. Greetings.