tool help

hmaandekokhmaandekok Posts: 4
edited March 16, 2007 10:54AM in SQL Packager Previous Versions
I am looking for a product to help me manage our development and training environments. My Scenario is that I restore development from productionion on a weekly basis. But that database references objects on a different database. So Ideally I would like to complete the weekly restore as it is scheduled. Then run a jobstep to update stored procedures to point to the correct databasename

for instance
I could like a utility that would update references inside stored procedures, views, UDF's

my_prod_db.dbo.table1 --> my_test_db.dbo.table1

Does this packager tool handle this scenario?

Comments

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

    I wouldn't think that you could do this with Packager. If you want to rename objects and want to update all of the objects that reference it, you'll probably want to look at SQL Refactor. Then again I think it might have issues with objects that communicate between databases.
Sign In or Register to comment.