Changing Crystal Report datasource from Access to SQL DB

[former_member1303563]

I have over 100 legacy crystal reports which are pointing to older access database.

We recently migrated from access DB to SQL server DB. Few tables from access DB have been split into multiple granular tables in the new SQL server DB

What are the effective options to change datasource from access database to SQL server database without changing crystal report?

Is there a way to do bulk update without opening each and every crystal report?

[DellSC]

You could potentially use either the .NET or the Java SDK to update the reports where the tables are exactly the same in both databases. However, any reports where the tables have changed will have to be manually updated by opening the report in Crystal, Going to Database >> Set Location, selecting the old database connection in the top and new database in the bottom, and clicking "Update". Crystal will then have you remap any fields that don't match between the two.

-Dell

[former_member1303563]

Hi Dell,

Thank you for the response. Can you please share more details on .NET option to update the reports. Any code sample would be helpful.

Thanks,

Sandhya

[DellSC]

You can find all sorts of information about the .NET SDK in the wiki here, including links to download the integration with VS, the runtime, and sample code.

When you download the integration with VS, you'll need VS 2010 or newer and you can use either VB or C#. Run the downloaded .exe by right-clicking and selecting "Run as Administrator".

-Dell