Is it possible to have a "post Get latest" script?

Louis_Gigantisch · December 30, 2019 1:14PM

After doing a "Get latest" on my local database, I would like to run a tool that generates code from my updated database.

Is there functionality for a post "Get latest" script? Or executing a batch or something to that extent?

DanC · December 31, 2019 1:59PM

Hi @Louis_Gigantisch unfortunately this isn't a feature within SQL Source Control, if however you'd like to make a suggestion this can be made here - https://redgate.uservoice.com/forums/39019-sql-source-control

Alternatively, if I'm understanding the scenario correctly you can use SQL Compare to compare the branch from Source Control to the live database and generate a deployment script that way.

Hope this helps!

Louis_Gigantisch · January 3, 2020 11:19AM

Thanks for your response. The post script I'm hoping to execute is not for deployment, but solely for development, but I'll have to look into the options there; maybe that will be viable.

DanC · January 3, 2020 11:23AM

You're welcome! if you have any other issues or questions please don't hesitate to contact us at support!

David Atkinson · January 6, 2020 7:48PM

Louis_Gigantisch said:

Thanks for your response. The post script I'm hoping to execute is not for deployment, but solely for development, but I'll have to look into the options there; maybe that will be viable.

@Louis_Gigantisch - Out of interest, what is your post script doing? Knowing this would help us suggest a solution. One option that springs to mind is trying to use xp_cmdshell in a post-deployment script.

Louis_Gigantisch · January 8, 2020 11:30AM

We have an ASP.NET project that generates code from the database using SQLMetal. Currently, we run SQLMetal on every project build, but ideally it only runs when the database has changed. Running it only after every "Get latest" would be preferable.

David Atkinson · January 8, 2020 4:30PM

Louis_Gigantisch said:

We have an ASP.NET project that generates code from the database using SQLMetal. Currently, we run SQLMetal on every project build, but ideally it only runs when the database has changed. Running it only after every "Get latest" would be preferable.

I see. The only option I can think of is if you create a batch file and use the SQL Compare command line instead of the built in "get latest" feature. This way you can configure the SQLMetal command to run afterwards.

Is it possible to have a "post Get latest" script?

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk