Settings and activity
11 results found
-
3 votesDani Avni shared this idea ·
-
3 votesDani Avni supported this idea ·
-
2 votesDani Avni shared this idea ·
-
1 voteDani Avni shared this idea ·
-
1 vote
An error occurred while saving the comment Dani Avni shared this idea · -
6 votesDani Avni shared this idea ·
-
6 votesDani Avni shared this idea ·
-
4 votesDani Avni shared this idea ·
-
4 votesDani Avni shared this idea ·
-
8 votesDani Avni shared this idea ·
-
75 votes
An error occurred while saving the comment Dani Avni commentedanother option is to have in SQL Source Control the ability to auto create migration scripts for specific scenarios. so i would map the renamed elements (like in sql compare) and have the change script generated automatically
An error occurred while saving the comment Dani Avni commentedusing SQL Source Control 3 and SQL Compare 10.2
i renamed a table from X to Y. as others noted, SQL source control sees the change as drop X and create Y. i want to create a migration script but that would take too long as the script has to drop relations with other tables, related SPROCS and that would take too long to write and debug.on the other side, SQL Compare 10.2 knows how to handle a rename of a table. all i have to do is map the tables and i get the table renamed with a few clicks.
my suggestion: allow on commit on sql source control to add rename hints that sql compare can use. for example on the commit i will define a migration script as a rename of X to Y. that in turn will cause SQL compare to see this hint and automatically set up a rename of table X to Y
Dani Avni supported this idea ·
Screenshot attached