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
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?