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

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
SkerwAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
lcohanConnect With a Mentor Database AnalystCommented:
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
 
lcohanDatabase AnalystCommented:
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
 
SkerwAuthor Commented:
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
 
SkerwAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.