Compare Dbs while in one all prefixes in names were removed
maxima
Posts: 6
We are in transition from SQL 2000 to 2005. Previous developer left new Db at a half-way basically.
I'd like to compare bases to figure out how much has to be done yet.
The problem is that objects have been moved from old to new have prefixes in their names removed.
Like old table fp_tbl_order, now it is just order or procedure fp_sp_do_something now is do_something sp.
Is there any way in SQL Compare 4 (I've got evaluation version) to script some rules for comparision?
Thank you.
I'd like to compare bases to figure out how much has to be done yet.
The problem is that objects have been moved from old to new have prefixes in their names removed.
Like old table fp_tbl_order, now it is just order or procedure fp_sp_do_something now is do_something sp.
Is there any way in SQL Compare 4 (I've got evaluation version) to script some rules for comparision?
Thank you.
Comments
Sorry, there isn't a way to ignore part of an object name. You may be able to get away with writing some kind of SQL script that uses sp_rename to rename all of the objects based on a cursor that does a query on the sysobjects table. Not for the faint of heart, though.