Activity overview
Latest activity by bitman
Okay I can confirm that changing anything in the schema, SCA detects the changes made except the data. Is there any configuration I missed? In the video tutorial it showed it is automatic by default. / comments
Okay I can confirm that changing anything in the schema, SCA detects the changes made except the data. Is there any configuration I missed? In the video tutorial it showed it is automatic by defa...
SCA Migrations SSMS VS
Hello,I followed the video tutorials from the university, specifically the Getting started with SQL Change Automation with Migrations, and I was able to create an SCA project successfully with my l...
Migration deployment from custom desktop app
Hello,I have a desktop application and during loading I check for any updates from our server. I want to ask if there is a way to also deploy the migrations I will generate using SCA to my target ...
Thank you @PlantBasedSQL for your reply. Thanks for the well wishes. I hope you are safe and healthy as well. I saw a video regarding this matter after I posted my question. https://www.red-gate.com/hub/university/courses/sql-change-automation/working-with-sql-change-automation-and-source-control/working-with-sql-change-automation-and-source-control/existing-databases I am trying to follow it and hopefully is the answer to my query. Thank you. / comments
Thank you @PlantBasedSQL for your reply. Thanks for the well wishes. I hope you are safe and healthy as well.I saw a video regarding this matter after I posted my question.https://www.red-gate.co...
I hope to get some advice regarding my question on #4 please? Thank you. / comments
I hope to get some advice regarding my question on #4 please? Thank you.
Baseline for existing database
Hello,I have an existing database that I want to use for SCA as my baseline. I followed the video tutorials but I do not want to create a baseline migration that will be run on my existing databas...
Thank you guys for chiming in. I appreciate the feedback. I will take your comments into account and plan accordingly. With regards to #4, my app is a desktop application and during loading I check for any updates from our server. I want to ask if there is a way to also deploy the migrations I will generate using SCA to my target database? I mean, does the project I created in SCA sufficient to be an executable application for migration deployment? Or I need to move the migration files inside my application and run it from there? Sorry for a rookie question but if there is a solid solution already, I would rather use that instead of reinventing the wheel. Thank you very much. / comments
Thank you guys for chiming in. I appreciate the feedback. I will take your comments into account and plan accordingly.With regards to #4, my app is a desktop application and during loading I chec...