Redgate SQL Source Control recommended workflow for dev-test-live databases
We are trying to get started with SQL Source control and have some questions.
This is what I am aiming towards. Does this look like it will work?
- Modify dev database tables/procs
- Commit to dev git branch on dev PC
- Push changes to central repo
- Repeat steps 1-3 for each change
- Merge dev branch into test branch
- Use SQL Source ConGtrol "Get Latest" on test branch
- Apply changes to test DB
- Repeast steps 5 - 8 but from test to live
Note: - Using "Shared database" development model.
Questions:
- Does this look like it will work?
- Can SQL Source Control apply the changes to the test and live databases
- or do I need to purchase a copy of SQL Compare for the dev server to perform this task?
- Fix the diagram here: http://goo.gl/l2mJdt
- More notes & experiences in my Google Doc
Great that you're deploying a versioned copy of your database changes from the repository, that's really good continuous delivery practise in my eyes.
Have a few suggestions about your questions (I have my Red Gate hat on)
Usually wouldn't recommend connecting SQL Source Control to your live environment. It polls to look for changes, and that is may not something you want on your live system. The recommendation is to use SQL Compare instead to make one off deployments to UAT/Production systems. Alternatively the Red Gate Deployment Manager product may be of interest to you.
You ask above about Shared/Dedicated mode in test. It doesn't matter if you are using a shared database for your developers in your dev branch, and then a dedicated model in your test branch. If the only changes to the test database are coming from one place (e.g. your git deployments) then it's probably better to run that database in dedicated mode.
I've drawn a diagram with some tweaks to yours. Not sure if you are using a CI server, but I've added in where that could fit into the process too. This diagram assumes dedicated modes for the two developers, but that could be a shared database instead.
- Updating and join on multiple rows, which row's value is used?
- What changed about the Statement.execute() between sqljdbc4 and mssql-jdbc?
- Varchar datetime with EDT in it convert into datetime
- LINQ: Why does a union of a union throw error message "IQueryable<...> does not contain a definition for 'Union'"?
- SQL Logic doesn't work
- Aggregation: Category missing in SQL subquery
- Error copying data from SQL Server to Redshift via a linked server connection
- Backup SQL Schema Only?
- Row wise average in SQL Server
- a *FUTUREPROOF* Project reference, to connect to SQL Server?
- Error for Invalid length parameter passed to SUBSTRING function
- Why is Query Optimizer Underestimating and Causing Data Spill to tempdb?
- SQL Server Management Studio Schema View
- Drop User from SQL Server Database?
- Create failed for Database
- SQL Server Express localdb.msi offline installer
- Loading data into SQL Server using Pandas dataframe
- Data has always changed(SQL Server Management Studio)
- SQL Server : generate random numeric string 27 characters long
- SQL Server Restore Error: Directory lookup for the file "db.mdf" failed
- Use dynamic database name in a stored procedure
- Why Does SQL Update Top apparently reduce locking even when no records are updated?
- "Type character does not declare data type" error
- Stopping repeated XML Headers
- C# filling a dataset from the database
- Microsoft SQL join on longitudinal data
- Add SSIS to existing SQL Server instance
- Cannot start LocalDB
- Remove all spaces from a string in SQL Server
- How to check the existence of related records in group by query?