Comments
Sort by recent activity
Hi there,
Does this work with the UI synchronising? If it does fail in the UI what object and object type does it fail on?
I understand that this isn't always possible, but is it going to be possible to provide snapshots of the databases in question?
Regards,
Jonathan / comments
Hi there,
Does this work with the UI synchronising? If it does fail in the UI what object and object type does it fail on?
I understand that this isn't always possible, but is it going to be possi...
Hi there,
Can you please post the entire output so that we can see at what point the error occurred? You can truncate the object list within the output if it is too long.
Thanks,
Jonathan / comments
Hi there,
Can you please post the entire output so that we can see at what point the error occurred? You can truncate the object list within the output if it is too long.
Thanks,
Jonathan
Hi rickybibi,
That option is actually an internal one and should not being displayed in VS or the API help, hopefully we will tidy this up shortly. It was put in place to serve a possible future need, but will have no effect on the scripts produced as the engine will overide this setting.
More grandural control of objects like indexes, triggers etc, is a very popular request, and one we are consider addressing.
Regards,
Jonathan / comments
Hi rickybibi,
That option is actually an internal one and should not being displayed in VS or the API help, hopefully we will tidy this up shortly. It was put in place to serve a possible future n...
Claire,
Sorry, about your problems. Yes SQL Compare command line doesn't cope very well when it cannot locate the snapshots that you specify. It is rather ugly and we will be fixing this in the next point release.
Regards,
Jonathan / comments
Claire,
Sorry, about your problems. Yes SQL Compare command line doesn't cope very well when it cannot locate the snapshots that you specify. It is rather ugly and we will be fixing this in the n...
Hi there,
Sorry, about your problem, my colleage and I have just been trying to work around it, but cannot come up with a way to do this as a SQL Server job. Now, I think we really need to add an "don't raise an error on identical" switch to the command lines. I have added a request for this, I cannot promise it will be done in the next release, but we will try to fit it in.
Regards,
Jonathan / comments
Hi there,
Sorry, about your problem, my colleage and I have just been trying to work around it, but cannot come up with a way to do this as a SQL Server job. Now, I think we really need to add an ...
Hi there,
If you are refering to the API, then I am afraid that there is no one method to do this. You will have to loop through the differences object and test each database object's DifferenceType in turn to detect where the differences in the database is.
Regards,
Jonathan / comments
Hi there,
If you are refering to the API, then I am afraid that there is no one method to do this. You will have to loop through the differences object and test each database object's DifferenceTy...
Hi there,
You can find the SQL Compare API samples at http://www.red-gate.com/support/samples.htm
Regards,
Jonathan / comments
Hi there,
You can find the SQL Compare API samples at http://www.red-gate.com/support/samples.htm
Regards,
Jonathan
Thanks for your comments. You're right that we could have made it a lot clearer which features would be Pro features and what features would be in the Standard Edition.
We are very appreciative of the feedback provided by many of our users during the Beta phase. Therefore we have decided for those Beta testers who posted five or more items of feedback to the forum, to upgrade their Standard license to a Pro license free of charge. If you feel that you fall into this category, please make yourself known to sales@red-gate.com.
Regards,
Jonathan / comments
Thanks for your comments. You're right that we could have made it a lot clearer which features would be Pro features and what features would be in the Standard Edition.
We are very appreciative of ...
Hi there,
SQL Compare retrieves the schema extractly as it is in your production environment and then tries to execute in your development environment. It doesn't alter the syntax in anyway, therefore if your development server does not have access to a linked server that an object in your production database requires then the synchronisation will fail.
The error message given is actually SQL Server's error message not SQL Compare's as SQL Compare does not check for dependencies outside of the target database. SQL Compare cannot at the current time refactor objects on the fly to avoid such problems.
At the moment I am at a lost to explain why the manually execution of the alter proc statement produces a different result, unless the linked server information has been changed in the proc?
Regards,
Jonathan / comments
Hi there,
SQL Compare retrieves the schema extractly as it is in your production environment and then tries to execute in your development environment. It doesn't alter the syntax in anyway, there...
Andreas,
Unfortunately you are correct, SQL Compare does not support full text indexes on views. We hope to have this resolved shortly.
Regards,
Jonathan / comments
Andreas,
Unfortunately you are correct, SQL Compare does not support full text indexes on views. We hope to have this resolved shortly.
Regards,
Jonathan