Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server Reporting services migration from SQL 2000 to SQL Server 2012 Express

Posted on 2012-03-16
4
Medium Priority
?
510 Views
Last Modified: 2012-06-06
I need to migrate an application from SQL Server 2000 to SQL Server 2012 express edition.
The challenge I am looking for help is to migrate the SQL Server Reports from SQL 2000 to SQL Express edition 2012.

Could anyone give me a link with guidance on what to expect and how to perform this migration.

Any advise would be greatly appreciated.

Thank You
0
Comment
Question by:Skerw
  • 2
  • 2
4 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 37730444
I believe the only 100% bullit proof and safe option you have would be to migrate them one by one as painfull it looks like.
0
 

Author Comment

by:Skerw
ID: 37735218
lcohan

Thank You for your response. I appreciate it.

You are saying SQL 2012 express edition would open the reports from SQL 2000 without having them to rewrite?

Thank You
0
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 37738029
After you migrate them yes, however this means you would need to edit each one in BIDS (VS 2010) then save them, build and deploy to the new reporting services server under 2012.
0
 

Author Comment

by:Skerw
ID: 37758398
lcohan,

Thank You for your help. I am going to perform this task in a week or so and I will keep you posted with my observations
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question