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

Comments

1 comment

Add comment

Please sign in to leave a comment.