Is there an automated way to backup and restore? Also, the test environment is on a totally different server from the production environment.

I just need a copy of the live data in the test environment. I hope to get a fresh set of data for the test environment once a day.

How would I implement this in SSIS? The majority of my Weekly Sales rows do not match the employee rows.

Okay, let me look into this.

Wow, I wish I had known that earlier.

Good! Does that also apply to Visio 2010?

Thanks for the information. I hope to review that book over the holidays.

I also use Toad Data Modeler. In addition, I don't know if newer versions of Visio support ERDs that well, if at all.

Good point. I have modified the design accordingly.

For more information, the SCD might include the following attributes. This columns are from the source data.

SKU

Item Name

UPC

Adjustment Date

Current SRP

New SRP

Again, I'm wondering if we can create formulas in...

The project was temporarily put on hold, but now that it is back in play I have another question.

Yes, I think the SRP (Suggested Retail Price) column should be part...

I agree about putting the data in dimension table. The problem was in convincing co-workers. For some reason, someone wanted the data in the Dynamics AX system.

Sorry, I don't think I explained myself properly.

I WANT to have a step #3 like below. The original system (the one I did not build) skipped step #3....

The current system is functional but that's about it. There was apparently very little thought put into design of the current system. As a result, the system is...

Thank you for your response. I am inclined to put the price in a dimension, specifically a type 2 SCD.