Update SP & Table Structure that linked to same folder

jamesytl

Hi,

I am new to SQL Source Control and wish to ask something.

Is it possible to make all the DB that linked to the same working folder to be updated to same table structure and store procedure?

Currently I found the deployment function but it's not what I wanted as it update the table structure and store procedure of ONE db only at the moment.
But what i wish to do is updating the schema/store procedure of all the database.

Is the only way I can do is deploy the changes with script then create my own script/exe to run it at all the DB I wish to update?

Help are much appreciated. Thanks!

Sergio R

Hi James,

SQL Source Control's purpose is to source control your databases and allow a team of developers to work on the same DB seamlessly, it is not a deployment tool.

The best tool for your scenario would be SQL Compare:
http://www.red-gate.com/products/sql-de ... l-compare/

With SQL Compare you could compare and deploy from your source database directly to your target or from source control to the database. You could also generate a script with the changes.

It can also be used from the command line.

(comparing from or to Source Control and using the command line requires the Professional version of SQL Compare).

For more information on SQL Compare, please see the following:
https://documentation.red-gate.com/disp ... umentation

I hope this helps

Thank you,

jamesytl

Hi Sergio Rocha,

Thanks for the information.

I will ask my question at SQL Compare topic.

Much appreciated