Comments
Sort by recent activity
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...