Sunday, March 25, 2012

Crystal Reports to SQL Reporting Services Migration

Does anyone have any recommendations for the best approach to migrating
Crystal Reports to SQL Reporting Services?There isn't a "quick" convert option - Crystal being a proprietary report
format limits you from stripping out information about the report. You could
use the "report defintion" option to find out details about the report,
etc...but this is purely for informational purposes
The reality is you will have to re-build your reports. The only reusable
components would be the SQL statement, if optimized, or other source info
(stored proc's, etc...). The rest would be fresh.
--
MGM
"CaskeyRW" wrote:
> Does anyone have any recommendations for the best approach to migrating
> Crystal Reports to SQL Reporting Services?|||Thanks for the reply. That's what I expected, but thought it was worth asking.
"MGM" wrote:
> There isn't a "quick" convert option - Crystal being a proprietary report
> format limits you from stripping out information about the report. You could
> use the "report defintion" option to find out details about the report,
> etc...but this is purely for informational purposes
> The reality is you will have to re-build your reports. The only reusable
> components would be the SQL statement, if optimized, or other source info
> (stored proc's, etc...). The rest would be fresh.
> --
> MGM
>
> "CaskeyRW" wrote:
> > Does anyone have any recommendations for the best approach to migrating
> > Crystal Reports to SQL Reporting Services?|||There is help on the way. A Microsoft Partner Readiness seminar covers, in
part, migration from Crystal Reports to SQL RS
http://www.msreadiness.com/
http://www.msreadiness.com/WS_abstract.asp?eid=15003226
--
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"CaskeyRW" <CaskeyRW@.discussions.microsoft.com> wrote in message
news:CB4241D5-5972-46ED-A3D8-B84EEB72E3AD@.microsoft.com...
> Does anyone have any recommendations for the best approach to migrating
> Crystal Reports to SQL Reporting Services?|||Jeff,
Thanks for the reply. We've already moved forward doing it manually and
have actually completed the migration. Once we developed kind of a process
or pattern for doing the conversion, it wasn't too bad.
Regards,
Rick
"Jeff A. Stucker" wrote:
> There is help on the way. A Microsoft Partner Readiness seminar covers, in
> part, migration from Crystal Reports to SQL RS
> http://www.msreadiness.com/
> http://www.msreadiness.com/WS_abstract.asp?eid=15003226
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "CaskeyRW" <CaskeyRW@.discussions.microsoft.com> wrote in message
> news:CB4241D5-5972-46ED-A3D8-B84EEB72E3AD@.microsoft.com...
> > Does anyone have any recommendations for the best approach to migrating
> > Crystal Reports to SQL Reporting Services?
>
>

No comments:

Post a Comment