move reports service system

--____KFWWXQZZZBOZZRPOGMHS____
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
hi all
how can move all reports system (web and database) from one box to other = box.
thx. from spain.
_______________________________
* Alberto Garc=EDa S=E1nchez
* Subdirector Inform=E1tica
* Autobar Spain, S.A.
* Email: agarcia@.autobar-spain.com
* Web: www.autobar-spain.com * Telef. +34 916787345 _______________________________
___________________________________________________________________________=
Este mensaje se dirige exclusivamente a su destinatario
y puede contener informaci=F3n privilegiada o confidencial. Si no es vd. = el destinatario
indicado, queda notificado de que la utilizaci=F3n, divulgaci=F3n y/o = copia sin
autorizaci=F3n est=E1 prohibida en virtud de la legislaci=F3n vigente. Si = ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma v=EDa y proceda a su destrucci=F3n.
This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
___________________________________________________________________________
--____KFWWXQZZZBOZZRPOGMHS____
Content-Type: multipart/related; boundary="____BIYGCADYSRXUIZFQTHGP____"
--____BIYGCADYSRXUIZFQTHGP____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
&
hi all

how can move all reports system (web and database) from one box to = other box.

thx. from spain.



_______________________________

* Alberto Garc=EDa S=E1nchez* Subdirector Inform=E1tica* = Autobar Spain, S.A.* Email: agarcia@.autobar-spain.com* Web: www.autobar-spain.com * Telef. +34 916787345 = _______________________________

__________________________________________________________________= _________Este mensaje se dirige exclusivamente a su destinatarioy = puede contener informaci=F3n privilegiada o confidencial. Si no es vd. el = destinatarioindicado, queda notificado de que la utilizaci=F3n, = divulgaci=F3n y/o copia sinautorizaci=F3n est=E1 prohibida en virtud = de la legislaci=F3n vigente. Si harecibido este mensaje por error, le = rogamos que nos lo comuniqueinmediatamente por esta misma v=EDa y = proceda a su destrucci=F3n. This message is intended = exclusively for its addressee and may containinformation that is = CONFIDENTIAL and protected by professional privilege.If you are not = the intended recipient you are hereby notified that anydissemination, = copy or disclosure of this communication is strictlyprohibited by law. = If this message has been received in error, pleaseimmediately notify = us via e-mail and delete it.___________________________________________= ________________________________
--____BIYGCADYSRXUIZFQTHGP____--
--____KFWWXQZZZBOZZRPOGMHS____--This is a multi-part message in MIME format.
--=_NextPart_000_00F6_01C5434B.2C395450
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi alf,
look here, there a kb from MS for it:
http://support.microsoft.com/default.aspx?scid=3D842425
Moving the database will affect the web because the data for the UI is =stored in SQL Server.
First you have to install the Reporting Services on the second box of =course, because there are many entries made during the installation =process which won=B4t be done without the instal process and just plain =copying.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
<alf> schrieb im Newsbeitrag =news:%23$4m8kfQFHA.3120@.TK2MSFTNGP10.phx.gbl...
hi all
how can move all reports system (web and database) from one box to =other box.
thx. from spain.
_______________________________
* Alberto Garc=EDa S=E1nchez
* Subdirector Inform=E1tica
* Autobar Spain, S.A.
* Email: agarcia@.autobar-spain.com
* Web: www.autobar-spain.com * Telef. +34 916787345 _______________________________
=_________________________________________________________________________=__
Este mensaje se dirige exclusivamente a su destinatario
y puede contener informaci=F3n privilegiada o confidencial. Si no es =vd. el destinatario
indicado, queda notificado de que la utilizaci=F3n, divulgaci=F3n y/o =copia sin
autorizaci=F3n est=E1 prohibida en virtud de la legislaci=F3n vigente. =Si ha
recibido este mensaje por error, le rogamos que nos lo comunique
inmediatamente por esta misma v=EDa y proceda a su destrucci=F3n.
This message is intended exclusively for its addressee and may contain
information that is CONFIDENTIAL and protected by professional =privilege.
If you are not the intended recipient you are hereby notified that any
dissemination, copy or disclosure of this communication is strictly
prohibited by law. If this message has been received in error, please
immediately notify us via e-mail and delete it.
=_________________________________________________________________________=__
--=_NextPart_000_00F6_01C5434B.2C395450
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi alf,
look here, there a kb from MS for =it:
http://support.microsoft.com/default.aspx?scid=3D842425">http://s=upport.microsoft.com/default.aspx?scid=3D842425
Moving the database will affect the web =because the data for the UI is stored in SQL Server.
First you have to install the Reporting Services =on the second box of course, because there are many entries made during the installation process which won=B4t be done without the instal process =and just plain copying.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
schrieb im Newsbeitrag news:%23$4m8kfQFHA.=3120@.TK2MSFTNGP10.phx.gbl...
hi all

how can move all reports system (web and database) from one box =to other box.

thx. from spain.



_______________________________

* Alberto Garc=EDa S=E1nchez* Subdirector Inform=E1tica* =Autobar Spain, S.A.* Email: agarcia@.autobar-spain.com* Web: http://www.autobar-spain.com">www.autobar-spain.com * Telef. +34 916787345 _______________________________

=________________________________________________________________=___________Este mensaje se dirige exclusivamente a su destinatarioy puede contener = informaci=F3n privilegiada o confidencial. Si no es vd. el destinatarioindicado, queda notificado de que la utilizaci=F3n, =divulgaci=F3n y/o copia sinautorizaci=F3n est=E1 prohibida en virtud de la =legislaci=F3n vigente. Si harecibido este mensaje por error, le rogamos que nos =lo comuniqueinmediatamente por esta misma v=EDa y proceda a su destrucci=F3n. This message is intended exclusively for =its addressee and may containinformation that is CONFIDENTIAL and =protected by professional privilege.If you are not the intended recipient you =are hereby notified that anydissemination, copy or disclosure of this communication is strictlyprohibited by law. If this message has =been received in error, pleaseimmediately notify us via e-mail and =delete =it.__________________________________________________________________=_________

---

--=_NextPart_000_00F6_01C5434B.2C395450--

Move reports created by Report Builder

I have created a number of reports using Report Builder, and I would
like to move them to a new report server 2005 instance (I have
redeployed the underlying model to the new report server) and
associated model. Any easy way to do this?
Thanks,
Paul.Reporting Services Scripter v2
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Paul" <prayner@.matrixbancorp.com> wrote in message
news:1134682199.968299.138840@.o13g2000cwo.googlegroups.com...
>I have created a number of reports using Report Builder, and I would
> like to move them to a new report server 2005 instance (I have
> redeployed the underlying model to the new report server) and
> associated model. Any easy way to do this?
> Thanks,
> Paul.
>|||Thanks very much Jasper! Much appreciated.
Paul.

Move linked reports to new server

I am moving reporting services to a new server and I want to move the
reports, file structure, and linked reports over as well. I have created a
few parameterized base reports that I can simply re-deploy, but there are
numerous linked reports - they run specific parameters on a scheduled basis
and distribute via subscriptions - that were created on the server itself.
Is there any simple way to move the linked reports over to the new server?
Perhaps go into the old server and just grab certain files and copy them over?The easiest way is to write a script file to do this (or .Net program using
SOAP). There is no easy way using the UI.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Echinodermata" <Echinodermata@.discussions.microsoft.com> wrote in message
news:14E5B132-F351-42D1-8B74-92152FB5E60C@.microsoft.com...
>I am moving reporting services to a new server and I want to move the
> reports, file structure, and linked reports over as well. I have created
> a
> few parameterized base reports that I can simply re-deploy, but there are
> numerous linked reports - they run specific parameters on a scheduled
> basis
> and distribute via subscriptions - that were created on the server itself.
> Is there any simple way to move the linked reports over to the new server?
> Perhaps go into the old server and just grab certain files and copy them
> over?
>|||Does anyone know of any example scripts on how to copy reports to a server? I
have a product that I am distributing - part of it utilizes reports in
reporting services - I would like to be able to install those reports with a
setup program - has anyone done this? If someone could point me in the right
direction, it would be greatly appreciated.
"Daniel Reib [MSFT]" wrote:
> The easiest way is to write a script file to do this (or .Net program using
> SOAP). There is no easy way using the UI.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Echinodermata" <Echinodermata@.discussions.microsoft.com> wrote in message
> news:14E5B132-F351-42D1-8B74-92152FB5E60C@.microsoft.com...
> >I am moving reporting services to a new server and I want to move the
> > reports, file structure, and linked reports over as well. I have created
> > a
> > few parameterized base reports that I can simply re-deploy, but there are
> > numerous linked reports - they run specific parameters on a scheduled
> > basis
> > and distribute via subscriptions - that were created on the server itself.
> >
> > Is there any simple way to move the linked reports over to the new server?
> > Perhaps go into the old server and just grab certain files and copy them
> > over?
> >
>
>

MS Reports with out SQL Server

I have a customer using Oracle DB and Oracle Reports (older version), they
need the feature to export reports to excel and like the MS Reporting
Services format. Most of the reports have already been developed in VS2k3
for another customer that uses strictly MS SQL and I have converted these to
VS2k5 and been looking at the ReportViewer winform and webform controls. I
would like to use it in local mode because this customer doesnâ't want a
SQLServer installed anywhere. Ideally I would just like to pass an Oracle DB
connection string to the report viewer and let the SQL in the rdl file do its
work. But, as I understand it, I have to pass the DataTable directly to the
report when using local mode? So is there anyway to open an rdl file and
obtain the SQL? I can then query the DB and pass the resulting data back to
the ReportViewer.LocalReport.DataSource. Any example code would help, I
canâ't imagine all this is required just to run a simple report without a
SSRS? My customer now wants me to consider using crystal reports instead but
I would like to stay on the MS format. Will there be any better options for
this situation in future versions of ReportingServices or the ReportViewer?There are so many examples on the web.
What seems to be a problem?
You can pass any data- no sql server required.
Can't you do something like that?
DataTable reportData = _controller.GetReportData();
rview.LocalReport.DataSources.Clear();
rview.Clear();
rview.Reset();
byte[] data = GetRDL();
MemoryStream ms = new MemoryStream(data);
rview.ProcessingMode = ProcessingMode.Local;
rview.LocalReport.LoadReportDefinition(ms);
ReportDataSource rds = new ReportDataSource("ds", reportData);
rview.LocalReport.DataSources.Add(rds);
rview.RefreshReport();
"Drew" <Drew@.discussions.microsoft.com> wrote in message
news:AE726184-FFE0-4297-974D-C795D02F0E38@.microsoft.com...
>I have a customer using Oracle DB and Oracle Reports (older version), they
> need the feature to export reports to excel and like the MS Reporting
> Services format. Most of the reports have already been developed in VS2k3
> for another customer that uses strictly MS SQL and I have converted these
> to
> VS2k5 and been looking at the ReportViewer winform and webform controls. I
> would like to use it in local mode because this customer doesn't want a
> SQLServer installed anywhere. Ideally I would just like to pass an Oracle
> DB
> connection string to the report viewer and let the SQL in the rdl file do
> its
> work. But, as I understand it, I have to pass the DataTable directly to
> the
> report when using local mode? So is there anyway to open an rdl file and
> obtain the SQL? I can then query the DB and pass the resulting data back
> to
> the ReportViewer.LocalReport.DataSource. Any example code would help, I
> can't imagine all this is required just to run a simple report without a
> SSRS? My customer now wants me to consider using crystal reports instead
> but
> I would like to stay on the MS format. Will there be any better options
> for
> this situation in future versions of ReportingServices or the
> ReportViewer?|||hey buddy i am so sorry that Oracle doesn't have as many features as
SQL Server does.
you should tell them to re-evaluate their database of choice.
-Aaron
Oleg Yevteyev myfistname wrote:
> There are so many examples on the web.
> What seems to be a problem?
> You can pass any data- no sql server required.
> Can't you do something like that?
> DataTable reportData = _controller.GetReportData();
> rview.LocalReport.DataSources.Clear();
> rview.Clear();
> rview.Reset();
> byte[] data = GetRDL();
> MemoryStream ms = new MemoryStream(data);
> rview.ProcessingMode = ProcessingMode.Local;
> rview.LocalReport.LoadReportDefinition(ms);
> ReportDataSource rds = new ReportDataSource("ds", reportData);
> rview.LocalReport.DataSources.Add(rds);
> rview.RefreshReport();
>
> "Drew" <Drew@.discussions.microsoft.com> wrote in message
> news:AE726184-FFE0-4297-974D-C795D02F0E38@.microsoft.com...
> >I have a customer using Oracle DB and Oracle Reports (older version), they
> > need the feature to export reports to excel and like the MS Reporting
> > Services format. Most of the reports have already been developed in VS2k3
> > for another customer that uses strictly MS SQL and I have converted these
> > to
> > VS2k5 and been looking at the ReportViewer winform and webform controls. I
> > would like to use it in local mode because this customer doesn't want a
> > SQLServer installed anywhere. Ideally I would just like to pass an Oracle
> > DB
> > connection string to the report viewer and let the SQL in the rdl file do
> > its
> > work. But, as I understand it, I have to pass the DataTable directly to
> > the
> > report when using local mode? So is there anyway to open an rdl file and
> > obtain the SQL? I can then query the DB and pass the resulting data back
> > to
> > the ReportViewer.LocalReport.DataSource. Any example code would help, I
> > can't imagine all this is required just to run a simple report without a
> > SSRS? My customer now wants me to consider using crystal reports instead
> > but
> > I would like to stay on the MS format. Will there be any better options
> > for
> > this situation in future versions of ReportingServices or the
> > ReportViewer?