Activity overview
Latest activity by jkeil
SQL Compare Options
I have a case where I want to create an update script that is only for objects found in the source db and are missing in the target db. I am using the XML config file for the command line options,...
Filtering Triggers
I am aware of the general IgnoreTriggers option when using SqlCompare. Is there any way to filter triggers by name rather than all or none? I got an error when I tried to include an Include/Exclu...
Hi Brian,
Thanks for the reply...I figured that SQL Compare was generating the "Create" based on the database that it was referencing. Unfortunetly, sometimes the objects that I want to migrate over were not created with "dbo".
The workaround I came up with involved writing a console app to find all "Create" statements and add the prefix "dbo." to each one. It was necessary to do this rather than try to fix my SQL server role membership.
I would love to know how/when you come up with a programmatic workaround...
JeffK / comments
Hi Brian,
Thanks for the reply...I figured that SQL Compare was generating the "Create" based on the database that it was referencing. Unfortunetly, sometimes the objects that I want to migrate ov...
Assigning Object Ownership
I use sqlcompare to generate an update script that I shell out to OSQL via command line in Jscript. When the database objects are created, they are assigned to me as the owner (ie [unicru/jkeil].[...