alignement data

My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
StperAre you talking about transforming data? Have you explored DTS? See SQL
Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
My application has production server and backup sever for data reporting .
There is some tools in SQL 2K (or third part tool) for alignement data at
run time between two servers?
Thanks in advance
Stper|||Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||In that case, I'd strongly recommend transactional replication. It is meant
to satisfy reporting requirements.
Log shipping is ideal for maintaining standby servers, but not really for
reporting purposes.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
Hi Vyas,
It seems Stper need to syncronize the report server with production server
online.
Stper,
If above is the case you can go for either of the below approach
1. Transactional Replication
2. Log Shipping
This method will sync. the Report server database with report server.
Thanks
Hari
MCDBA
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> Are you talking about transforming data? Have you explored DTS? See SQL
> Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> My application has production server and backup sever for data reporting
.
> There is some tools in SQL 2K (or third part tool) for alignement data at
> run time between two servers?
> Thanks in advance
> Stper
>
>|||Thanks Hari, i think the Transactional Replication is the solution for my
problem. Now i must study the configuration
I found this an article in
www.awprofessional.com/articles/article.asp?p=170234
Do you have some suggestion for examples and/or configuration
Thanks
Stper
"Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> Hi Vyas,
> It seems Stper need to syncronize the report server with production server
> online.
> Stper,
> If above is the case you can go for either of the below approach
> 1. Transactional Replication
> 2. Log Shipping
> This method will sync. the Report server database with report server.
> Thanks
> Hari
> MCDBA
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> > Are you talking about transforming data? Have you explored DTS? See SQL
> > Server Books Online for more information.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> > "stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> > news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> > My application has production server and backup sever for data
reporting
> .
> > There is some tools in SQL 2K (or third part tool) for alignement data
at
> > run time between two servers?
> > Thanks in advance
> >
> > Stper
> >
> >
> >
>|||stper,
Books Online is a very valuable reference.
http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
to replication. There is a book coming soon on Snapshot and
Transactional replication from Hilary Cotter which is excellent, see the
link in my sig.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
stper wrote:
> Thanks Hari, i think the Transactional Replication is the solution for my
> problem. Now i must study the configuration
> I found this an article in
> www.awprofessional.com/articles/article.asp?p=170234
> Do you have some suggestion for examples and/or configuration
> Thanks
> Stper
> "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
>>Hi Vyas,
>>It seems Stper need to syncronize the report server with production server
>>online.
>>Stper,
>>If above is the case you can go for either of the below approach
>>1. Transactional Replication
>>2. Log Shipping
>>This method will sync. the Report server database with report server.
>>Thanks
>>Hari
>>MCDBA
>>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
>>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
>>Are you talking about transforming data? Have you explored DTS? See SQL
>>Server Books Online for more information.
>>--
>>HTH,
>>Vyas, MVP (SQL Server)
>>http://vyaskn.tripod.com/
>>
>>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
>>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
>>My application has production server and backup sever for data
> reporting
>>.
>>There is some tools in SQL 2K (or third part tool) for alignement data
> at
>>run time between two servers?
>>Thanks in advance
>>Stper
>>
>>
>|||i made the configuration and now i testing my first "PULL SUbscription".
Unfortunately i have my first error message : "Unexpected EOF encountered in
BCP data-file" when i run with alignement.
Do yuo have some suggestion ?
stper
"Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> stper,
> Books Online is a very valuable reference.
> http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> to replication. There is a book coming soon on Snapshot and
> Transactional replication from Hilary Cotter which is excellent, see the
> link in my sig.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> stper wrote:
> > Thanks Hari, i think the Transactional Replication is the solution for
my
> > problem. Now i must study the configuration
> > I found this an article in
> > www.awprofessional.com/articles/article.asp?p=170234
> > Do you have some suggestion for examples and/or configuration
> >
> > Thanks
> > Stper
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> > news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> >
> >>Hi Vyas,
> >>
> >>It seems Stper need to syncronize the report server with production
server
> >>online.
> >>
> >>Stper,
> >>
> >>If above is the case you can go for either of the below approach
> >>
> >>1. Transactional Replication
> >>
> >>2. Log Shipping
> >>
> >>This method will sync. the Report server database with report server.
> >>
> >>Thanks
> >>Hari
> >>MCDBA
> >>
> >>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> >>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> >>
> >>Are you talking about transforming data? Have you explored DTS? See SQL
> >>Server Books Online for more information.
> >>--
> >>HTH,
> >>Vyas, MVP (SQL Server)
> >>http://vyaskn.tripod.com/
> >>
> >>
> >>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in message
> >>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> >>My application has production server and backup sever for data
> >
> > reporting
> >
> >>.
> >>
> >>There is some tools in SQL 2K (or third part tool) for alignement data
> >
> > at
> >
> >>run time between two servers?
> >>Thanks in advance
> >>
> >>Stper
> >>
> >>
> >>
> >>
> >>
> >
> >|||After testing and testying i can say (like Pitagora) : EUREKA !!!
now i must tuning the task but the functionality work very well.
Thanks
Stper
"stper" <stefano.perabo@.speedautomazione.it> ha scritto nel messaggio
news:eZICqZzbEHA.596@.TK2MSFTNGP11.phx.gbl...
> i made the configuration and now i testing my first "PULL SUbscription".
> Unfortunately i have my first error message : "Unexpected EOF encountered
in
> BCP data-file" when i run with alignement.
> Do yuo have some suggestion ?
> stper
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> ha scritto nel messaggio
> news:#7aQdhybEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > stper,
> >
> > Books Online is a very valuable reference.
> > http://www.mssqlserver.com/replication/primer_p1.asp has a nice primer
> > to replication. There is a book coming soon on Snapshot and
> > Transactional replication from Hilary Cotter which is excellent, see the
> > link in my sig.
> >
> > --
> > Mark Allison, SQL Server MVP
> > http://www.markallison.co.uk
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> >
> >
> > stper wrote:
> > > Thanks Hari, i think the Transactional Replication is the solution for
> my
> > > problem. Now i must study the configuration
> > > I found this an article in
> > > www.awprofessional.com/articles/article.asp?p=170234
> > > Do you have some suggestion for examples and/or configuration
> > >
> > > Thanks
> > > Stper
> > >
> > > "Hari Prasad" <hari_prasad_k@.hotmail.com> ha scritto nel messaggio
> > > news:#AoYEqxbEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > >
> > >>Hi Vyas,
> > >>
> > >>It seems Stper need to syncronize the report server with production
> server
> > >>online.
> > >>
> > >>Stper,
> > >>
> > >>If above is the case you can go for either of the below approach
> > >>
> > >>1. Transactional Replication
> > >>
> > >>2. Log Shipping
> > >>
> > >>This method will sync. the Report server database with report server.
> > >>
> > >>Thanks
> > >>Hari
> > >>MCDBA
> > >>
> > >>"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> > >>news:uDRYaMxbEHA.3988@.tk2msftngp13.phx.gbl...
> > >>
> > >>Are you talking about transforming data? Have you explored DTS? See
SQL
> > >>Server Books Online for more information.
> > >>--
> > >>HTH,
> > >>Vyas, MVP (SQL Server)
> > >>http://vyaskn.tripod.com/
> > >>
> > >>
> > >>"stefano perabò" <stefano.perabo@.speedautomazione.it> wrote in
message
> > >>news:%23wzR3DxbEHA.556@.tk2msftngp13.phx.gbl...
> > >>My application has production server and backup sever for data
> > >
> > > reporting
> > >
> > >>.
> > >>
> > >>There is some tools in SQL 2K (or third part tool) for alignement
data
> > >
> > > at
> > >
> > >>run time between two servers?
> > >>Thanks in advance
> > >>
> > >>Stper
> > >>
> > >>
> > >>
> > >>
> > >>
> > >
> > >
>sql