A way to syncronize data in sql express I have 2 servers, one with SQL standard and the second one is express.
I wanted to know if there is any tool or any way to synchronized the databases and making it work like replication without the replication (because i don't have the agent in the express edition of corse).
Thanks.
You could try Windows Synchronization Manager 

https://technet.microsoft.com/en-us/library/ms151193(v=sql.105).aspx

Windows Synchronization Manager is a utility available with Microsoft Windows 2000 and later versions. If Microsoft SQL Server is running on the same computer as Synchronization Manager, you can do the following:

Synchronize a subscription.

Reinitialize a subscription.

Remove a subscription.


It is particularly useful for synchronizing subscriptions on SQL Server Express, because this version of SQL Server does not include SQL Server Agent, which, by default, runs the replication agents on other versions of SQL Server.