migrating sql 2005 - 2008 R2

  • Hello,

    What is the best way to migrate reports from SQL 2005 - 2008? I have 200+ reports, so opening one at a time in VS and then deploying is not an option.

    Also, I have a ton of subscriptions. Is there a way to move them to a new server as well?

    Thank you all in advance!

    SQL-TG

    The are no problems, only solutions. --John Lennon

  • In the past I've used RSscripter when I was in the same position as you. It might take a couple of goes to get the config right but does a good job. There's a link for it http://thandor.net/article/28 here

    ETA - There weren't any subscriptions on the server I was looking at - so I don't know how it handles those.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • Thanks!

    The are no problems, only solutions. --John Lennon

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply