Ability to generate changes to file locally so we can manually commit with other changes
I would like it to update the files but not commit as I generally like to commit a set of related changes together.
i.e. chaning the database schema and an on screen form to display new columns, they should appear as one commit. Currently I have to do two seperate commits
-
Rob
commented
This is similar to these:
http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/470565-edit-the-working-base-location-on-my-local-machine
http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/827725-allow-commits-to-occur-with-other-code-changes
http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/677655-allow-me-to-specify-where-to-save-the-working-base?ref=title -
Hi Renko,
We have another tool called SQL Compare Pro, http://www.red-gate.com/products/SQL_Compare, which allows you to a synch a db to a scripts folder. You can then commit/get latest manually using your source control system.
SQL Compare Pro also has a command line capability (http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Compare&c=SQL_Compare%5chelp%5c8.1%5cSC_CL_Working_With_Command_Lines.htm).
-
Hi Fayez,
In most cases, SQL Source Control and SQL Compare Pro will be compatible. There are some fixes in SQL Source Control that SQL Compare does NOT handle yet.
SQL Compare Pro can read the SQL Source Control format, but SQL Source Control can not read the SQL Compare Pro format. I hope this makes sense. What I mean is, you must use SQL Source Control to link and do the initial commit to source control. Then, you can use TSVN to checkout the database folder to a working area, use SQL Compare Pro to synch to that working area, and then commit using TSVN. SQL Source Control should then pick up those changes so that the latest commits appear in the other db developers "Get Latest" tab if you are working in a dedicated db model.
I hope this makes sense. Please let us know if you have any problems with this.
-
Renko Karman
commented
Maybe if the option to getlatest from a local folder is also added, this could allow people with any source control system to work with the product (although you would need to getlatest and commit on your source control system manually). If on top of that there is a "run command line" event option added to this tool, that manual getlatest/commit could be scripted even.
-
Fayez Moussa commented
Would the generated files be compatible with the SQL Source Control tools?
Would other users be able to update their databases using SQL Source Control from the files that I generate via sql compare pro and commit manually? -
Great idea! This way db changes could be committed in the same changeset as application changes.
You can use SQL Compare Pro to script the database to files and then commit these changes. There is a 14 day free trial on our website at http://www.red-gate.com/products/SQL_Compare. Just select "Database" as the Source and "Scripts Folder" as the target. Once you set this up, you can save the project in SQL Compare to make generating the script files easier the next time.
