tool help
hmaandekok
Posts: 4
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?
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
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.