How can we help you today? How can we help you today?

Compare Dbs while in one all prefixes in names were removed

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.
maxima
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hello,

    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.