How to add Store proc,Functions and Views to Migration Folder and SQL project both

VM_SQL

How to add Store proc and Views to Migration Folder and SQL project both

I need to sync Stored proc,Functions and view from DB to VS project using SQL change automation and then checkin to version control and use release script for deployment. How to add SQL objects in Migration Folder as Release script and add same objects to VS SQL project.  
 if any question then please let me know.

Thanks,
VM_SQL

Tianjiao_Li

Hi,

Thanks for posting your question.

Please find the documentation here: https://documentation.red-gate.com/sca/developing-databases/working-with-the-visual-studio-extension
 
https://documentation.red-gate.com/sca/developing-databases/concepts/version-control 

I hope those help but do let us know if you have any further questions.

VM_SQL

Thanks for the response.

I referred below article which you share but this shows manual addition of scripts to Migration folder by Copying. How we can automate this process of adding scripts to Migration script automatically.

https://documentation.red-gate.com/sca/developing-databases/working-with-the-visual-studio-extension/applying-changes-to-a-database-in-visual-studio

VM_SQL

Thanks for the response.

I referred the article which you share but this shows manual addition of scripts to Migration folder by Copying. How we can automate this process of adding scripts to Migration script atu

https://documentation.red-gate.com/sca/developing-databases/working-with-the-visual-studio-extension/applying-changes-to-a-database-in-visual-studio

Tianjiao_Li

Hi @VM_SQL

To import and generate the scripts by SQL Change Automation, please kindly check this page:
https://documentation.red-gate.com/sca/developing-databases/working-with-the-visual-studio-extension/generating-migrations-in-visual-studio

If there is still anything missing, please just let me know!