Activity overview
Latest activity by ElliotRodriguez
Thanks for the clarification. That is interesting regarding the transaction limitation and role creation.
We love the tool, we love the support we get too - but the object dependency issues we run into make it difficult sometimes. We appreciate the input. / comments
Thanks for the clarification. That is interesting regarding the transaction limitation and role creation.
We love the tool, we love the support we get too - but the object dependency issues we run ...
And now SQL Compare fails because the deployment script is STILL trying to execute the migration scripts on the database! And of course they fail because the script references objects that don't exist, which I can't get because the migration scripts are run FIRST. / comments
And now SQL Compare fails because the deployment script is STILL trying to execute the migration scripts on the database! And of course they fail because the script references objects that don't ex...
I am using SQL Compare instead, and side note - I still do not understand why, if SQL Compare fails a deployment, Roles and Users are not part of a rolled back transaction.
I received an error deploying from SQL Compare, because DTC was not running, and after I toggled it on and ran the same deployment script, I got another error complaining of a User that was already created. How can a failure not roll back the entire database to the same state it was in before the failure? This has been a long standing issue and I really wish it were addressed (or at least explained). / comments
I am using SQL Compare instead, and side note - I still do not understand why, if SQL Compare fails a deployment, Roles and Users are not part of a rolled back transaction.
I received an error depl...
Migration Script Failures
I intend to file a ticket for this, but I wonder if anyone has found a solution in the interim.
I have a new database that I am connecting to SQL Source Control (dedicated database). The source con...
Ignore option for database/server in synonyms not working
I am pulling new synonyms in from one source to another via SQL Source Control. We are not using Compare at this stage as its a promotion from DEV to our local TEST database.
Although I have "Datab...
I have submitted another support request for this issue. / comments
I have submitted another support request for this issue.
Thanks Andrew - that is a great idea. / comments
Thanks Andrew - that is a great idea.
Disabling comparisons for fully qualified database names
We have an environment where developers put development and test databases on a single server.
We have a number of ways that development and test databases are set up right now. For example, if we ...
I have a ticket submitted for this, but it appears that the portion of the script that creates the user is outside the transaction scope defined by Compare when it generates the script. / comments
I have a ticket submitted for this, but it appears that the portion of the script that creates the user is outside the transaction scope defined by Compare when it generates the script.