Replication to SQL 2005

Hello all,
We have merge replication setup between 3 servers. SQL1, SQL2 and SQL3.
We have installed SQL2005 on a ReportingServer and want to be able to
popluate the database on SQL2005 with data from SQL1. How can we set this up?
We want to avoide setting up the whole replication process again as the
database is 25 GB and SQL3 is updated via a telephone line.
Thanks
Regards
Ishan
Ishan,
if the ReportingServer is RO apart from the replication synchronization, I'd
use transactional replication. I'd also consider dong a nosync
initialization to set things up with a database of this size.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Replication newbie, help please...

Dear all,
I have a web application that uses sql2005 database. And a local windows
application that uses exactly same sql2005 database structure. I want to
synchronize databases. When new record added from web I want them into my
local db. When my local db changes I want them to go my server database.
Is this "replication" concept for this kind operation. there are many
resources on the net but I could not figure out how.
Any sample documentation, link on tghe web, sample project, anything is
wellcome. but I need to synchronize 2 databases in different locations.
Best regards.
Have a look in BOL for setting up merge replication. The exact setup depends
on how the web application and the local windows application can connect -
over tcp/ip (trusted?) or if not https?
Rgds,
Paul Ibison

Replication Monitor Times and Handheld Synchronization times

Hello
When i am Synchronizing(SQL2005 merge replication)
I can see the duration of the Synchronization on the Replication
monitor and i can see that lets say an "initial loading" of the
database with lots of data is taking 4 minutes but on the handheld if i
take the time of the Synchronize() command that can take up to 30
minutes.
Why is this happening? Am I doing something wrong here?
Thanks
Savvas Christodoulou
The replication monitor shows the time it took for the server side
reconciler to write the initial data to the .OUT file in the IIS server.
The writing of the OUT file to the device can take longer depending on your
network connection etc.
<savvaschr@.nodalsoft.com.cy> wrote in message
news:1162307433.787568.183190@.e3g2000cwe.googlegro ups.com...
> Hello
> When i am Synchronizing(SQL2005 merge replication)
> I can see the duration of the Synchronization on the Replication
> monitor and i can see that lets say an "initial loading" of the
> database with lots of data is taking 4 minutes but on the handheld if i
> take the time of the Synchronize() command that can take up to 30
> minutes.
> Why is this happening? Am I doing something wrong here?
> Thanks
> Savvas Christodoulou
>
|||Thanks a lot ,
I finaly understood what was going on just after i post this message.
Regards

Replication in SQL server2005

Hi there i need an advice on replication in sql2005

i've heared that i can't make replication between two cluster servers installed on them sql2005 and they are in different domains so please can you tell me is that true and if is what can we do to solve this because they are in different places and we can't give them the same domains of IPs

thanks

I"m going to move this thread to the replication group.|||I've never heard of that restriction. You can replicate between machines, regardless of whether they are even in a domain. You simply have to specify login credentials for each of the replication agents.