View t sql script prior to apply changes in get latest
Dayton_
Posts: 3 New member
SLQ Source control is connected to git. I am doing get latest. I select an object that is in source control that I want to apply to the database. How do I view the script that SQL source control will use prior to clicking apply changes.
I feel like this should be answered somewhere, but my google foo must be low. If I need to use SQL Change automation instead, that can be the answer and I'll just need to figure out that tool.
Thanks!
I feel like this should be answered somewhere, but my google foo must be low. If I need to use SQL Change automation instead, that can be the answer and I'll just need to figure out that tool.
Thanks!
Tagged:
Best Answer
-
David Atkinson Posts: 1,457 Rose Gold 2Yes, "get latest" isn't the correct way to deploy to Production. Most customers fire up a copy of SQL Compare Pro and use this. Just set the source to the SQL Source Control scripts folder, and set the target to be your Production server and run through the deployment wizard. SCA is appropriate if you want to use a migrations-based approach for deployments, which is popular for automated release processes.David Atkinson
Product Manager
Redgate Software
Answers
Product Manager
Redgate Software