Comments
Sort by recent activity
Thanks for the quick reply David. SQL Compare is a great product which I have been using for over a year. This is the first hiccup I have had with it, but I must say it is a big one. I actually mostly use the SDK and wrote a wrapper application around it so SQL Refactor is not really a viable option.
As far as the renaming goes, I am not renaming the table itself, I am simply assigning it to a different security schema.
select * from sys.all_objects where type = 'U' and name = 'MyTable'
this contains a schema_id which can be located here:
select * from sys.schemas
The object_id within sys.all_objects remains the same throughout the life-cycle of the schema transfer. / comments
Thanks for the quick reply David. SQL Compare is a great product which I have been using for over a year. This is the first hiccup I have had with it, but I must say it is a big one. I actually ...
So you are saying the only way for SQL Compare to acknowledge a change of schema (owner) on a table object without detecting them as two entirely different objects is to use SQL Refactor? That would seem like a very limiting "feature" for SQL Compare. How unfortunate and short-sighted. / comments
So you are saying the only way for SQL Compare to acknowledge a change of schema (owner) on a table object without detecting them as two entirely different objects is to use SQL Refactor? That wou...