Skip to Content
Jul 29, 2020 at 07:36 PM

Changing Crystal Report datasource from Access to SQL DB


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?