tool help

hmaandekok

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?

JonathanWatts

Locking this topic as it has been crossed posted in the SQL Packager forum too, a response will be delivered there:

http://www.red-gate.com/messageboard/vi ... hp?p=16026