How can we help you today? How can we help you today?

tool help

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

2 comments

Sort by
  • 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
    JonathanWatts
    0
  • colin01

    For your weekly production-to-development restores, you need a solution that automates post-restore updates. SQL Change Automation or ApexSQL Diff can help. After restoring, run a job step to automatically update stored procedures to reference the correct development database names. This ensures all objects function properly without manual intervention. For the Italian translation requirement, you must use words "translate english to italian" in your configuration to handle any multi-language database objects.

    colin01
    0

Add comment

Please sign in to leave a comment.