x

How to migrate access reports to SQL Server 2008

Hi,

I am about to migrate from Access 2003 database to SQL Server 2008 R2 database using Import / Export Wizard.

My client has few reports in Access 2003. Will these reports will be migrated too while migrating database.

Can anyone pls help me with my above query ?

Thanks

more ▼

asked Oct 19, 2011 at 02:41 PM in Default

avatar image

jerill
41 11 14 15

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

No. Those won't be converted. There is not a native reporting utility within SQL Server itself. Instead there's a separate service called Reporting Services. Here's a mechanism for doing that.

more ▼

answered Oct 19, 2011 at 02:51 PM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

Hi Grant,

Thanks for your reply. So 1) I will move database from Access 2003 to SQL Server 2008 using Import / Export Wizard. 2) I will use SSRS to move reports from Access 2003 to SQL SErver 2008.

So, once I move reports, 1) Will report loose few of the features Or all the features will be preserved 2) And, will reports will be pointing to SQL Server 2008 after migration. Or I will have to do point them to SQL Server database manually.

Can you pls help me with above questions.

Thanks

Oct 19, 2011 at 03:15 PM jerill

You'll have to work with Reporting Services to ensure that the reports connect to the correct SQL Server instance. That should be part of the process outlined by Microsoft. Behavior of the reports might change, but anything you can do in Access, you do in Reporting Services, and a whole lot more. I'm not a Reporting Services expert, but if you post specific issues you have, I'll make sure someone I know who can answer those questions helps you out.

Oct 19, 2011 at 03:22 PM Grant Fritchey ♦♦

Thanks Grant will do that.

Can you pls pass me your email address if you dont mind. So that I can directly email you.

Thanks once again.

Oct 19, 2011 at 03:35 PM jerill

It's not on my profile?

Oct 20, 2011 at 03:25 AM Grant Fritchey ♦♦

@Grant Fritchey It is on your profile page, but the email address is visible only to the moderators. So other users see that asking you "how bout them Red Sox?" might be not a good idea, but they don't see your email :)

Oct 20, 2011 at 08:11 AM Oleg
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x52

asked: Oct 19, 2011 at 02:41 PM

Seen: 1332 times

Last Updated: Oct 19, 2011 at 02:41 PM

Copyright 2016 Redgate Software. Privacy Policy