This solution requires more SQL Server Lincenses. I can't do that . I also use smartkeys on my Serve database so I need temp keys on my remote databases.

Sorry. I don't want to buy a SFA Software, I want to discuss about DataBase Strategies for sync on remote Smart Devices DataBase ( SQLCE 3.5 ) with no direct...

First of all, thanks for Lynn Pettis,Jeff Moden,PaulB,ps,WayneS for your comments. All the points stressed out here are very important. As Jeff said, this is not a simple question and...

my services will not provide these features. It''s a good question in a ERP scope.

thanks for all the replies. The reason why I used the SAP sample was to give a rough sample of a change a complex single company system should take to...

Thanks for the reply. SAP is an ERP ( Single COMPANY ) System. To make it a MultiCOMPANY ERP would you create a COMPANY TABLE and use its CompanyID as...

I have almost 1 million records with information about the Postal Codes in Brazil in a SqlCe database in a HTC Touch 3G Phone. It works very nicely. Try to...

:-)thanks John and Paul. It's good to have a place to share concepts about DB Designs.

Thanks for the reply.

What John Marsh said is true. I have a product table and a competitors table. I made a compatibility table with two column. ( productID, competitorsID )...