tool help

hmaandekokhmaandekok Posts: 4
edited March 13, 2007 5:39AM in SQL Compare 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?


This discussion has been closed.