Re: SQLEXPRESS Replication?

Use merge replication for this.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"Edwin Smith" <smithgoldbug@xxxxxxx> wrote in message
news:%234jTqbGZIHA.4332@xxxxxxxxxxxxxxxxxxxxxxx
I have 2 servers in different cities connected with a VPN link. One is
running SQL 2005 Workgroup edition. The other is running SQL 2005 Express
edition.

Can I do replication such that transactions at either server can be
replicated to the other?

I am able to get it to work from the Server with Workgroup edition to the
server with Express but not the other way.

Do I need to have Workgroup Edition at both ends?

Thanks

Edwin


.

Relevant Pages

  • SQLEXPRESS Replication?
    ... The other is running SQL 2005 Express edition. ... Can I do replication such that transactions at either server can be replicated to the other? ... I am able to get it to work from the Server with Workgroup edition to the server with Express but not the other way. ...
    (microsoft.public.sqlserver.replication)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... I just promoted the remote DC last week, so I still have time to solve the replication issues. ... Domain Controller Diagnosis ... Connecting to directory service on server alpha. ... Performing upstream analysis. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... alpha server as soon as you can to get things going. ... A simple DNS replication test is to create a host record in the SBS server ... Domain Controller Diagnosis ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Replication Errors with Remote DC
    ... I did make the changes that you suggested on the DNS of my alpha server and rebooted. ... I did run the simple DNS test that you suggested by adding a host record to my SBS server. ... A simple DNS replication test is to create a host record in the SBS server and wait till it shows up in the remote server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Unable to decommission a Windows 2008 DC via dcpromo
    ... Can you open and compare sysvol and netlogon share on both DCs? ... Verifying that the local machine server2, ... The File Replication Service Event log test ... Latency information for 8 entries in the vector were ...
    (microsoft.public.windows.server.active_directory)
Loading