Crystal Reports - MS Access to MS SQL Server Migration

Question

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.

Posted 28-Jun-13 23:27pm

jenitshah

Updated 28-Jun-13 23:30pm

v3

Add a Solution

Comments

Mahesh Bailwal 29-Jun-13 5:44am

Why you are not using Dataset? You can create dataset at runtime.

http://vb.net-informations.com/dataset/dataset-create-without-database.htm

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Maciej Los · Answer 1 · 2013-06-29T23:47:00

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)[^]
More:
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. ;)