Home > IT Answers > AS/400 > Migrating SRS reports to new data structure
Nmenjivar
5 pts.
 Migrating SRS reports to new data structure
RDL, SQL, SRS
I'm migrating to a new database with different tables and fields but want to continue to use the SQL SRS reports that I previously had (there are hundreds of them). Is anyone aware of a tool that will allow me to map the new and old data structure and update the rdl files for SRS?

Software/Hardware used:
ASKED: September 5, 2008  10:59 PM
UPDATED: September 28, 2008  5:29 AM
RELATED QUESTIONS
Answer Wiki:
The only way to keep the reports the same would be if you were using stored procedures. You could then update the stored procedures and keep the reports the same. If you are using impeded SQL queries you'll need to edit them manually.
Last Wiki Answer Submitted:  September 28, 2008  5:29 am  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _