Migration to new servers

I have to migrate reports to two new servers. I tried simply moving the
databases over, but RS freaked. rsactivate and the other utilities are
problematic, to say the least (I freaked).
It seems like the easiest thing would be to install SQL RS on the new
servers, copy over all of the project files/reports, and then from within VS,
reset the project properties to the new server and redeploy.
Does this make sense? Is there an easier, or more reliable way?
--
Thanks,
CGWYou are correct. easiest is to install RS on new servers and then to the new
RS URL, you can just post your reports directly from Visual studio, or
however you deploy your reports today. This is the cleanest way to deploy as
well.
"CGW" wrote:
> I have to migrate reports to two new servers. I tried simply moving the
> databases over, but RS freaked. rsactivate and the other utilities are
> problematic, to say the least (I freaked).
> It seems like the easiest thing would be to install SQL RS on the new
> servers, copy over all of the project files/reports, and then from within VS,
> reset the project properties to the new server and redeploy.
> Does this make sense? Is there an easier, or more reliable way?
> --
> Thanks,
> CGW|||Thank you!
CGW
"Ram" wrote:
> You are correct. easiest is to install RS on new servers and then to the new
> RS URL, you can just post your reports directly from Visual studio, or
> however you deploy your reports today. This is the cleanest way to deploy as
> well.
> "CGW" wrote:
> > I have to migrate reports to two new servers. I tried simply moving the
> > databases over, but RS freaked. rsactivate and the other utilities are
> > problematic, to say the least (I freaked).
> >
> > It seems like the easiest thing would be to install SQL RS on the new
> > servers, copy over all of the project files/reports, and then from within VS,
> > reset the project properties to the new server and redeploy.
> >
> > Does this make sense? Is there an easier, or more reliable way?
> > --
> > Thanks,
> >
> > CGW