Reporting services migration from 2000 to 20005

Hi, I have been given the task of migrating our existing 2000 reports
from our MSSQL 2000 database etc to MSSQL 2005 / Reporting services.
Does anyone have any information (links, recommendations) about the
best way to approach this migration and any caveats about doing such a
migration?
Thanks
MarkusHow many reports are there to migrate ? You can open the same in 2005 and it
will automatically convert all the report in 2005, ofcourse it will prompt
you for converting and then change the datasource according to the 2005
server and deploy..
Amarnath,MCTS
"MarkusJNZ@.gmail.com" wrote:
> Hi, I have been given the task of migrating our existing 2000 reports
> from our MSSQL 2000 database etc to MSSQL 2005 / Reporting services.
> Does anyone have any information (links, recommendations) about the
> best way to approach this migration and any caveats about doing such a
> migration?
> Thanks
> Markus
>|||On Apr 16, 2:58 pm, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> How many reports are there to migrate ? You can open the same in 2005 and it
> will automatically convert all the report in 2005, ofcourse it will prompt
> you for converting and then change the datasource according to the 2005
> server and deploy..
> Amarnath,MCTS
>
> "Markus...@.gmail.com" wrote:
> > Hi, I have been given the task of migrating our existing 2000 reports
> > from our MSSQL 2000 database etc to MSSQL 2005 / Reporting services.
> > Does anyone have any information (links, recommendations) about the
> > best way to approach this migration and any caveats about doing such a
> > migration?
> > Thanks
> > Markus- Hide quoted text -
> - Show quoted text -
Hi, there are quite a few reports (Around 50) to be migrated.
Thanks
Markus|||50 is nothing. It will take an hour and a half at most to convert. My
suggestion is do this:
1. create a new directory and copy all the files over.
2. Open up the project in RS 2005 report designer.
3. Open up each report in the designer. When asked, have it convert to RS
2005
4. Save and close each report.
5. Deploy to RS 2005 server.
You can deploy RS 2000 reports to RS 2005 server but I found minor little
issues until I converted all my report to RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<MarkusJNZ@.gmail.com> wrote in message
news:1176705228.692526.51340@.d57g2000hsg.googlegroups.com...
> On Apr 16, 2:58 pm, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
>> How many reports are there to migrate ? You can open the same in 2005 and
>> it
>> will automatically convert all the report in 2005, ofcourse it will
>> prompt
>> you for converting and then change the datasource according to the 2005
>> server and deploy..
>> Amarnath,MCTS
>>
>> "Markus...@.gmail.com" wrote:
>> > Hi, I have been given the task of migrating our existing 2000 reports
>> > from our MSSQL 2000 database etc to MSSQL 2005 / Reporting services.
>> > Does anyone have any information (links, recommendations) about the
>> > best way to approach this migration and any caveats about doing such a
>> > migration?
>> > Thanks
>> > Markus- Hide quoted text -
>> - Show quoted text -
> Hi, there are quite a few reports (Around 50) to be migrated.
> Thanks
> Markus
>|||Hi ,
I have some 1000 reports to be migrated...
Is there any tools to migrate?
"Bruce L-C [MVP]" wrote:
> 50 is nothing. It will take an hour and a half at most to convert. My
> suggestion is do this:
> 1. create a new directory and copy all the files over.
> 2. Open up the project in RS 2005 report designer.
> 3. Open up each report in the designer. When asked, have it convert to RS
> 2005
> 4. Save and close each report.
> 5. Deploy to RS 2005 server.
> You can deploy RS 2000 reports to RS 2005 server but I found minor little
> issues until I converted all my report to RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <MarkusJNZ@.gmail.com> wrote in message
> news:1176705228.692526.51340@.d57g2000hsg.googlegroups.com...
> > On Apr 16, 2:58 pm, Amarnath <Amarn...@.discussions.microsoft.com>
> > wrote:
> >> How many reports are there to migrate ? You can open the same in 2005 and
> >> it
> >> will automatically convert all the report in 2005, ofcourse it will
> >> prompt
> >> you for converting and then change the datasource according to the 2005
> >> server and deploy..
> >>
> >> Amarnath,MCTS
> >>
> >>
> >>
> >> "Markus...@.gmail.com" wrote:
> >> > Hi, I have been given the task of migrating our existing 2000 reports
> >> > from our MSSQL 2000 database etc to MSSQL 2005 / Reporting services.
> >>
> >> > Does anyone have any information (links, recommendations) about the
> >> > best way to approach this migration and any caveats about doing such a
> >> > migration?
> >>
> >> > Thanks
> >> > Markus- Hide quoted text -
> >>
> >> - Show quoted text -
> >
> > Hi, there are quite a few reports (Around 50) to be migrated.
> >
> > Thanks
> > Markus
> >
>
>