Replication Sync on Windows Vista

On windows XP there is a Synchronize program in Accessories. When I run our replication scripts on a SQL Server Express on the XP machine and start the Synchronize program there are items there that allow me to replicate as well as set a schedule, etc.

On Windows Vista there is a Sync Center, but replication doesn't show up here.

I've searched high and low on Google and am not coming up with anything useful, which leads me to believe this is something very simple that I'm overlooking...

Does anyone know how to make your replication show up on the Sync Center in vista, or is there another application that I should download?

Thanks,

Brian

I could be wrong, but I do not believe those are the same. I think Sync Manager in Vista is a built-in tool for synchronizing PDA's and thing like that. However, so I do not mis-speak, I am testing that now because we are also at the point of testing synchronization with Vista.

I will let you know what i find.

Scott

|||To add files to Sync Center, on the (Vista) machine you want to have the offline copy on, open explorer and navigate to the network share the original file or directory is on. Right-click and on the context menu select "Always Available Online." The SyncCenter icon will be superimposed on the icon to show it is being copied.

Replication Sync on Windows Vista

On windows XP there is a Synchronize program in Accessories. When I run our replication scripts on a SQL Server Express on the XP machine and start the Synchronize program there are items there that allow me to replicate as well as set a schedule, etc.

On Windows Vista there is a Sync Center, but replication doesn't show up here.

I've searched high and low on Google and am not coming up with anything useful, which leads me to believe this is something very simple that I'm overlooking...

Does anyone know how to make your replication show up on the Sync Center in vista, or is there another application that I should download?

Thanks,

Brian

I could be wrong, but I do not believe those are the same. I think Sync Manager in Vista is a built-in tool for synchronizing PDA's and thing like that. However, so I do not mis-speak, I am testing that now because we are also at the point of testing synchronization with Vista.

I will let you know what i find.

Scott

|||To add files to Sync Center, on the (Vista) machine you want to have the offline copy on, open explorer and navigate to the network share the original file or directory is on. Right-click and on the context menu select "Always Available Online." The SyncCenter icon will be superimposed on the icon to show it is being copied.

Replication Scripts Stopped Working..

I have a merge publication that I always create with a script but has now stopped working with what appears to be a complete server problem.

The actual command i am executing is a simple

sp_addpublication_snapshot

but it fails with

Msg 50000, Level 16, State 1, Procedure sp_add_jobstep_internal, Line 253

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

Msg 3931, Level 16, State 1, Procedure sp_MSadd_repl_job_unsafe, Line 376

The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction.

I have tried recreating the database from scratch, renaming it, renaming the publication, even disabling the publications altogether but it makes no difference. There is nothing in the sql or event logs and I cant do any work until Ive got past it - help!

I am using SQL 2005 SP2 if that makes any difference.

Thanks

Andy

It looks like you have an uncommitted transaction hanging around. Open a query window and type:

Commit Tran

GO

It will either tell you that there are no transactions to commit or commit the uncomplted transaction. At that point, re-run your script.

Hope this helps...

Scott

Replication Scripts Stopped Working..

I have a merge publication that I always create with a script but has now stopped working with what appears to be a complete server problem.

The actual command i am executing is a simple

sp_addpublication_snapshot

but it fails with

Msg 50000, Level 16, State 1, Procedure sp_add_jobstep_internal, Line 253

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

Msg 3931, Level 16, State 1, Procedure sp_MSadd_repl_job_unsafe, Line 376

The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction.

I have tried recreating the database from scratch, renaming it, renaming the publication, even disabling the publications altogether but it makes no difference. There is nothing in the sql or event logs and I cant do any work until Ive got past it - help!

I am using SQL 2005 SP2 if that makes any difference.

Thanks

Andy

It looks like you have an uncommitted transaction hanging around. Open a query window and type:

Commit Tran

GO

It will either tell you that there are no transactions to commit or commit the uncomplted transaction. At that point, re-run your script.

Hope this helps...

Scott

Replication scripts for 2000 same as 2005 ?

I am curious to know if i script the replication scripts for creating
publisher, publication,etc on 2000, can i safely run them on sql 2005 or are
there some changes to the metadata ?
Thanks
Yes you can run them no problem.
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
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23hK0gj8yHHA.1208@.TK2MSFTNGP03.phx.gbl...
>I am curious to know if i script the replication scripts for creating
>publisher, publication,etc on 2000, can i safely run them on sql 2005 or
>are there some changes to the metadata ?
> Thanks
>
|||Have a look in BOL at : "How to: Upgrade Replication Scripts".
The original ones should work OK but the recommendation is to make changes
to the security of the jobs.
Cheers,
Paul Ibison
sql

Replication scripts

Hi,

The company I work for delivers their developed software together with two W2K3 servers using SQL Server 2000. These two servers has two roles, production and backup, and if the production server is offline or if anything happens to it, the backup server becomes the production server. When the original production server is back online, it becomes the backup server.

I have struggled with replication on these two machines. What we would like is to have scripts for these servers. These scripts should be general so that they could be run at both servers. The current production server is setup as distributor and publisher, and the backup server is setup with a pull subscription. Also, when the subscriber is seetup, it should update its database from the publisher

Does anyone have general scripts like this?

Best,
/M

Sorry, it's not clear to me exactly what the problem is. Did you try setting up replication using the wizards? Once it's set up, you can script out the replication scenario in Enterprise Manager.|||

Is replication a part of the solution, or something you need to setup?

Would setting up Database Mirroring between these 2 servers be an option? If do then please refer to http://msdn2.microsoft.com/en-us/library/ms177412.aspx.

This posting is provided AS IS with no warranties, and confers no rights.