SQL Server - Production DB Schema vs. Reporting DB Schema. Should they be the same? -
We've recently put in a new production database usage. The schema of this database is optimized for OLTP We are also preparing to implement a reporting server to use for reporting purposes. I do not believe that we should use the same schema for our reporting database, as That we do for our production database and do it to replicate the data. For those people who have worked with different production and reporting databases, you have chosen to use the same database schema for your reporting database, or a schema that is more for reporting. Is efficient; For example, maybe something more denormalized? Thanks for considering this. I think the reporting database schema should be optimized for reporting - so you can get your data An ETL process will need to be loaded in my experience. In my experience I was quick at that point that the production schema does not meet my reporting requirements If you are starting your own reporting project then I would suggest That you rep...