Menu
Suppose that there are 3 databases for
As far as I know, Staging database need to be in sync with Production database But,
When we are developing, we can do whatever we want with Dev database and change schema. Now here comes the Chicken & Egg problem.
To test in Staging, Staging database schema need to be changed according to changes made in Dev database. But the Staging database need to be in sync with Production.
How do you guys get around this problem?
624
A staging database is a user-created PDW database that stores data temporarily while it is loaded into the appliance.
A Staging database assists in getting your source data into structures equivalent with your data warehouse FACT and DIMENSION destinations. It also decouples your warehouse and warehouse ETL process from your source data.
A temporary storage area in which data is processed during an extract, transform and load procedure.
The staging environment must be isolated with no connections to any part of the production environment, including the production database.
You need to write all of you changes to the dev database as SQL migration scripts that get run in a certain order. Do not change the database structure unless it is in a script. Do not update, insert or delete any rows unless it is in a script.
Ideally have a way to track which scripts have been run against any version of the database you find.
Then you can update stage as follows.
Once everything works ...
108
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
