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
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