Hi All,
I need your valuable inputs about the production change in our database that is affecting reports, the application team has introduced an additional field to the tables in our database, with addition of that field we have to add an additional join condition and there are around 200 reports that are built based on that table and most of the reports are table joins and only a few of them are command objects, my question is what is the best approach to update the reports with minimal down time or is there is a way to do the change with out any down time.
We have Crystal Server 2011 and SQL server 2008 R2 database.
Thanks in advance!
I need your valuable inputs about the production change in our database that is affecting reports, the application team has introduced an additional field to the tables in our database, with addition of that field we have to add an additional join condition and there are around 200 reports that are built based on that table and most of the reports are table joins and only a few of them are command objects, my question is what is the best approach to update the reports with minimal down time or is there is a way to do the change with out any down time.
We have Crystal Server 2011 and SQL server 2008 R2 database.
Thanks in advance!