Worksheet 51 to copy from HQ database to each store database

We would like to use worksheet 51 to copy data from the HQ database to each store database. Is there a syntax in the SQL to reference the HQ database?

It appears to can only make isolated edit/delete/updates on each store d/b independently

thanks T.

Reply to
T Parks
Loading thread data ...

Reply to
convoluted

thanks for the reply. The problem is it's a custom table at HQ that we want to sync up with a version at each store. Hence the problem in trying to reference the HQ database in the sql statement

thanks T.

"c> DO NOT USE worksheet 51 to copy data from hq to stores....use the appropriate

Reply to
T Parks

When worksheets process, they're not actually linked across the two (store and HQ) databases, info is passed through temp tables, so the answer is: no. On the other hand, there's other options like back-end SQL server linking that could easily accomplish what you're looking to do from what I gather. If you were to set-up the HQ database as a linked db at each location with the same name, then you could use a 51 to pass a query down and run on each location's db which would grab from HQ. This would NOT work if there's firewalls or other barriers that would stand in the way of a SQL linked server connection. If you'd like more information/help, please feel free to contact me ;)

YidMo

"T Parks" wrote:

Reply to
YidMo

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.