What are the challenges you face when working across database platforms? Take the survey

Compare Dbs while in one all prefixes in names were removed

maximamaxima Posts: 6
edited March 24, 2006 1:52PM in SQL Compare Previous Versions
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.


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    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.
Sign In or Register to comment.