- posted
18 years ago
Retail Management System database needs primary keys in all tables
- Vote on answer
- posted
18 years ago
All tables of RMS have primary key.. or a IDENTITY key..
Table.ID or Table.TableNumber
antonio
- Vote on answer
- posted
18 years ago
yup, we ran into the same issue and finally stopped trying to replicate tables. Figured we'd have to write SP's to copy and schedule if push came to shove. See below for more details.
--------------------------
The RMS synch application is disabling a trigger on the itemdynamic table. While a table is being replicated, SQL prohibits change to the structure because the destination must match the structure of the table exactly to be able to receive repilicated data. If you change the table on the source but not the destination, replication breaks. To preserve performance in the future, reporting should be done on a replicated copy of the data on a reporting server. Per our discussion, we will drop replication on the database for now, you will check with the verdor to see what the extent of table change is, and we can determine the best way to make the data available to the business