Activity overview
Latest activity by chev265
Great that you may well be fixing that in the next release, but if it is resolved in the manner you describe then that wouldn't actually help me.
With regards to the feature request, you have it right. If that feature was implemented then that would do the trick and would in fact help me out a lot.
Thanks for all your help. / comments
Great that you may well be fixing that in the next release, but if it is resolved in the manner you describe then that wouldn't actually help me.
With regards to the feature request, you have it ri...
I am using V6.2, and you are right that's what it does if you select to include dependencies (which I wasn't).
But, the thing is the script will fail anyway because there is already an object in the destination database with that name (the view). And the foreign keys cannot be created against a view as well so you end up with mutliple errors. I want it to completely ignore those foreign keys that cannot be scripted. / comments
I am using V6.2, and you are right that's what it does if you select to include dependencies (which I wasn't).
But, the thing is the script will fail anyway because there is already an object in th...
Hi,
Thanks for your reply. I have just been preparing the databases to send through to you and actually discovered the source of the problem. In the database where the foreign key exists (source) the foreign table is a table, but the destination database that table is actually a view hence the foreign key cannot actually be created! oops.
Is there a way to filter out those differences? I don't want to filter out all foreign constraint differences, only those that cannot be created.
Sorry for the trouble.
Thanks
James / comments
Hi,
Thanks for your reply. I have just been preparing the databases to send through to you and actually discovered the source of the problem. In the database where the foreign key exists (source)...
Foreign Key differences not included in SQL Scrip
Hi, I am currently evaluating SQL Compare 6.2 and am having trouble with foreign keys.
I have a table called Budget that is listed in the 'objects that exist in both but are different' category. T...