1 / 14

Migrating from Crystal Reports to Microsoft SQL Server Reporting Services

Required Slide. SESSION CODE: BIP203. Migrating from Crystal Reports to Microsoft SQL Server Reporting Services. Srinath Venkatasubramanian Alliance Manager Sonata Software Limited. Agenda. Customer concerns with migration Manual Migration practices Framework based Migration Approach

kueng
Download Presentation

Migrating from Crystal Reports to Microsoft SQL Server Reporting Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Required Slide SESSION CODE: BIP203 Migrating from Crystal Reports to Microsoft SQL Server Reporting Services SrinathVenkatasubramanianAlliance Manager Sonata Software Limited

  2. Agenda • Customer concerns with migration • Manual Migration practices • Framework based Migration Approach • Critical success factors

  3. Customer Concerns .. Achieving a smooth transition.. How do I ensure that the same look and feel of the reports How do I ensure the same functionalities after migration Some reports are simple, but there are several complex reports How do I make the transition seamless What are the timelines for Migration What is the Return on Investment I do not have enough expertise in SQL reporting services Does my in house team have the time for doing this migration

  4. Manual Migration Practices • Compare & Build • Document & Build • Start from Scratch

  5. Compare & Build • Features • Step by step migration by having crystal report open in one window and BI Development studio in another window • Identify feature of Crystal and replicate in SSRS • Map the characteristics of Crystal report to that of SSRS report • Advantages • If followed in a structured manner will result in good quality reports • Relatively simple and fastest method • Disadvantages • Conversely – an unstructured process will result in a poor quality report • Requires resource to have a good understanding of both environments • All inefficiencies of Crystal will also be replicated

  6. Document & Build • Features • One resource will study the crystal Report and document the understanding • Documents may be validated by business users • Second resource will build SSRS based in the above document • Advantages • Does not require the same resource to have knowledge of both technologies • A document is created leading to better maintenance (especially if validated by business user) • Developer is not encumbered by crystal’s report structure - will develop SSRS in the most efficient manner • Disadvantages • Documenting and validating could be a long process • Fresh development (especially Query building) could be time consuming • More Time consuming resulting in increased cost.

  7. Start from Scratch • Features • Re engineer the entire Reporting philosophy • A Business Intelligence approach as opposed to transaction reporting • Fresh reports can be designed and old obsolete reports can be discarded • Advantages • A new set of reports addressing current business challenges • Best utilization of the features of SQL Server (BI) • Disadvantages • Time consuming process • Resistance by end users to a new system • Requires resources form architects to designers to developers

  8. Framework Based Approach

  9. Critical Success Factors • Look & Feel • End users should not perceive any change; No retraining of the users on the new reports • There should not be any requirement for modifying pre printed stationery • Features & Performance • Every feature available in Crystal Reports should be mapped in SSRS • Identify work around solutions wherever a direct map is not available • Exploit Key features of SSRS like Excel Reporting, improved Graphics • No performance degradation in SSRS reports • Timelines & Costs. • Leverage your existing investments in SQL Server and reduce your TCO on your reporting solution Cut down high licensing costs Overcome the lack of an integrated database and reporting platform Overcome forced upgrades by database & reporting solutions vendors. • Overcome the limitation of existing reporting solutions

  10. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

  11. Required Slide Complete an evaluation on CommNet and enter to win!

  12. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

  13. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

  14. Required Slide

More Related