Activity overview
Latest activity by jgonzalez
Is there a reason you have to have them separate? SQL Compare always generates the foreign key statements after the table in every script I have ever seen.
We script out our entire database into an "Objects" directory and let SQL Compare organize the sub directories beneath it however it wants. / comments
Is there a reason you have to have them separate? SQL Compare always generates the foreign key statements after the table in every script I have ever seen.
We script out our entire database into ...
SqlCompare cmdline with xml arguments not genning syncscript
I have a powershell script that uses an xml template to build an xml arguments file. I want to use this xml arguments file to compare a script directory to a database and generate a script to sync...
Then you have to uncheck the Ignore Indexes option. You can script it out with the primary key if you do that. / comments
Then you have to uncheck the Ignore Indexes option. You can script it out with the primary key if you do that.
Did you have ignore indexes checked? Ignoring indexes also ignores the primary key. / comments
Did you have ignore indexes checked? Ignoring indexes also ignores the primary key.
Ignoring Indexes also Ignores Primary Keys
We are using SQL Compare to restore databases from production and then sync them to our sql source code in source control.
Non clustered indexes to us, are more of an operational concept rather tha...