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 |
|
bobby_zak
Starting Member
3 Posts |
 Posted - 2004-07-28 : 10:04:59
|
| Hey everyone. I'm really new to forums n stuff but i really need the help so i figured this would be the best place to start. Here's my problem.At the moment i use two identical databases. One exists as SQL server CE on my PDA and another one on a SQL server on my computer. I use the PDA for work and want to be able to come home at the end of the day and insert the new data from the PDA into the SQ server database on the computer. Is there some way i can synchronise both the databases with the least amount of administrative effort. I'm quite new databases as well so any help would be really apperciated. Thank you.Bobby |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-28 : 13:41:50
|
| You will need to implement replication. Replication is not something that a newbie can easily pickup, IMO. I've been working with SQL Server for about 7 years now and replication for about 6 months. I am still not comfortable with replication yet. I would suggest reading up on replication in SQL Server Books Online to determine which type you'll need. Vyas' site has a lot of information about replication too:http://vyaskn.tripod.comTara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
bobby_zak
Starting Member
3 Posts |
Posted - 2004-07-30 : 12:08:32
|
| My database consists of about 7 tables. However, i will need to synchronise only one job at a time. I don't think the data will get very large. Will read up on the site for more on merge replication tho. Thanx heapz. Is merge Replication the only way to achieve the synchronisation i require? Thanx again |
|
|
|
|
|
|
Synchronising SQL Server with SQL CE