Database schema changes migration from one database to another in same or different server RRS feed

  • General discussion

  • Hi,

    In my project, I have 3  environment DB, DEV, QA. I am a database developer. So first I create any tables in DB environment and then took a script of database and run in DEV environment and then in QA environment. So Whenever there is any changes in database structure, I modify in DB environment and then took script of updated table and run in DEV and QA environment. I always did this manually. Is there any other way that track all the changes which I did in DB environment and on one click it reflect in DEV and QA environment ? Any piece of .Net code or useful link so that i can refer and do this all manual work just by one click ?

    Saturday, March 28, 2020 4:14 PM