Click here to Skip to main content
15,665,942 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
My Project is created on the following specifications :

-Windows 7 (32 Bit).
-Visual Studio 2010.
-Windows Form VB.NET Application.
-Microsoft Access 2007 As a Back-End.
-Using Crystal Reports As a Reporting Tool (Version for Visual Studio 2010)

Due to Storage Size Limitation of Database, I have divided All tables in Five Databases.

My problem is with Reporting tool, I am having multiple Databases i.e Five MS Access Databases.
Therefore I am not able to use queries and therefore I am not able to use DataSets.

I only pass some parameters to report and heavily dependent on those for Record Selection in the Reports relies on multiple databases.

Now, I want to migrate My application's back-end to Microsoft SQL Server.

I am worrying If I need to create a bunch of Reports Once More In the Conditions where I am not able to use Datasets.

Kindly suggest Me easiest method to Migrate all My crystal reports to SQL Server Database considering situations stated above.

Thank you.
Updated 28-Jun-13 23:30pm
Mahesh Bailwal 29-Jun-13 5:44am    
Why you are not using Dataset? You can create dataset at runtime.
jenitshah 29-Jun-13 5:49am    
Given solution is good but I decided to use It If no any other solution found, because It seems time consuming to create datasets for a lot of reports and their sub reports and all that from multiple databases.

Thanks a lot.

1 solution

If i understand you well, you have 5 databases (5 MS Access files) that's why you have a trouble to create reports.

First of all, change your database from MS Access to MS SQL Server Express edition.
How to do it? The simplest way whoch i know is to use SQL Server Migration Assistant for Access(AccessToSQL)[^]
Installing SQL Server Migration Assistant for Access(AccessToSQL)[^]
Access to SQL Server Migration: How to Use SSMA[^]
Other way is to use: SQL Server Import and Export Wizard[^]
If you're well familiarized with clear T-SQL language, you can use: OPENDATASOURCE (Transact-SQL)[^] or OPENROWSET (Transact-SQL)[^] commands.

Second, but not recommended solution is to use simple trick: create a 6. database and link all tables from those 5 files into this file. Now, you can use queries, datasets, etc. ;)
Share this answer
jenitshah 30-Jun-13 9:34am    
Thanks for ur reply.
I have no doubt for transferring data from Access to SQL Server about which You have given the help, I am having trouble in data source migration of crystal reports.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900