Click here to Skip to main content
15,569,696 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How to replicate data from sql server 2008 r2 express edition , if it is not possible then is there any third party tool for data replication from sql server 2008 r2 express edition, the matter is i want to transfer data from multiple machine from different location. those machine contain sql server 2008 r2 express edition.

thanks in advance. piku.
Posted

Look at Microsoft Sync Framework : http://msdn.microsoft.com/en-us/sync/bb736753.aspx[^]
 
Share this answer
 
Comments
piku da 6-Mar-13 2:24am    
I want transfer from first time. it should replication. But there is no publisher option.
Pull the .mdf and .ldf files (copy them) from the MSSQL directory (origin).
Add them to the MSSQL directory on the various "remote machines". Then on those machines, fire up SSMSE and attach them.
 
Share this answer
 
Comments
Maciej Los 6-Mar-13 15:34pm    
Yes, but first need to stop SQL services. ;)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900