Add to project but do not deploy?
Monday
Posts: 77 Silver 3
I had someone add a slew of objects (Stored procs, views, users, roles, tables) to a production DB outside of my normal deployment with SCA.
What is the best way to go about getting them into my project but making sure they don't try and deploy when I go to prod again? I have already updated my DEV database with these so SCA can now import them into my project. Do I just update the migration script to add a bunch of checks if object exists before the create statements? Or is there another way?
Thanks
What is the best way to go about getting them into my project but making sure they don't try and deploy when I go to prod again? I have already updated my DEV database with these so SCA can now import them into my project. Do I just update the migration script to add a bunch of checks if object exists before the create statements? Or is there another way?
Thanks
Tagged:
Best Answer
-
Sergio R Posts: 610 Rose Gold 5I think that's the best solution in this case.
Sergio
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools