What are the challenges you face when working across database platforms? Take the survey

Update SP & Table Structure that linked to same folder

jamesytljamesytl Posts: 6
edited November 1, 2016 5:10AM in SQL Source Control

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!


  • Options
    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,
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
  • Options
    Hi Sergio Rocha,

    Thanks for the information.

    I will ask my question at SQL Compare topic.

    Much appreciated
Sign In or Register to comment.