Solved

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

Posted on 2012-03-16
4
494 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

739 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