Replication with SQL Server 2005 Express Edition and SQL Compact Edition 3.5

Posted by Andy Gable on Server Fault See other posts from Server Fault or by Andy Gable
Published on 2009-10-09T17:37:12Z Indexed on 2010/03/19 12:01 UTC
Read the original article Hit count: 627

Filed under:
|
|
|

hi all,

I need some information on SQL Server 2005 Express edition. What I want to do is
have my central database servin local machine databases

IE

back office Cental database
|-------------------> Shop floor Terminal 1
|-------------------> Shop Floor Terminal 2
|-------------------> Shop Floor Terminal 3
|-------------------> Shop Floor Terminal 4
|-------------------> Shop Floor Terminal 5
|-------------------> Shop Floor Terminal 6

I want is so that Shop floor terminals would PULL down ANY changes to the database as
and when they happen (selected changes are needed change would be Add new item / Edit
Item info that is used by Shop floor terminal (ie price, description, sale group)

Is this possible with SQL 2005? I have the ability to make my own Sync Applciation but
I would need to know what to look for in the database that trigers a update

Many thanks for any advice you can give

Andy

© Server Fault or respective owner

Related posts about sql

Related posts about server