Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
roshana
Starting Member
31 Posts |
 Posted - 2009-12-10 : 00:13:18
|
| Hi all,I am using sqlserver 2008 compact edition in my local database and sql server enterprise edition in my server.At the end of the day i have to transfer the data from the local to my server.Each day we would have new data in the local DB (on the daily basis we would transfer the data to server and delete the data from local DB).so please advise me how to proceed Thanks in advanceRoshana |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-12-10 : 05:29:54
|
| Merge Replication would be the best way to update data from your local to server. http://technet.microsoft.com/en-us/library/ms152746.aspx |
 |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2009-12-15 : 14:52:04
|
| Hi.In my opinion, you can refer to the url below:http://technet.microsoft.com/en-us/library/cc786985(WS.10).aspxRegards,behrman.RAQ Report: Web-based Excel-like Java reporting tool |
|
|
|
brahmbhatt.virendra
Starting Member
2 Posts |
Posted - 2009-12-15 : 21:01:55
|
| Please follow the link below,http://technet.microsoft.com/en-us/library/ms152746.aspx |
|
|
|
|
|
|
which is the currect way to update data in server