Worksheet 51 to copy from HQ database to each store database

Posted by T Parks on July 8, 2008, 12:07 pm

Please log in for more thread options

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.

Posted by convoluted on July 8, 2008, 12:58 pm

Please log in for more thread options

DO NOT USE worksheet 51 to copy data from hq to stores....use the appropriate
worksheet to download hq data to the stores - there is one worksheet for a
specific area to update (ie 250 for item updates, 204 for departments and
categories, 209 for reason codes, etc) - worksheet 51 should only be used by
experienced technicians well versed in SQL when the store changes required
cannot be implemented via a standard worksheet - but out of the box, there is
a worksheet for whatever entry you've done in the hq db - if you're unsure
about which worksheet to use, consult the help guide (there is a worksheet
summary that explains what different worksheets do) - I would also strongly
recommend you hire an experienced rms partner fora day or two of training -
especially if headquarters is involved - hope this helps.....

"T Parks" wrote:

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

Posted by T Parks on July 10, 2008, 9:31 am

Please log in for more thread options

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.

"convoluted" wrote:

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

> worksheet to download hq data to the stores - there is one worksheet for a

> specific area to update (ie 250 for item updates, 204 for departments and

> categories, 209 for reason codes, etc) - worksheet 51 should only be used by

> experienced technicians well versed in SQL when the store changes required

> cannot be implemented via a standard worksheet - but out of the box, there is

> a worksheet for whatever entry you've done in the hq db - if you're unsure

> about which worksheet to use, consult the help guide (there is a worksheet

> summary that explains what different worksheets do) - I would also strongly

> recommend you hire an experienced rms partner fora day or two of training -

> especially if headquarters is involved - hope this helps.....

> "T Parks" wrote:

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

Posted by YidMo on July 14, 2008, 7:20 pm

Please log in for more thread options

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:

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

> "convoluted" wrote:

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

appropriate

> > worksheet to download hq data to the stores - there is one worksheet for a

> > specific area to update (ie 250 for item updates, 204 for departments and

> > categories, 209 for reason codes, etc) - worksheet 51 should only be used by

> > experienced technicians well versed in SQL when the store changes required

> > cannot be implemented via a standard worksheet - but out of the box, there

> > a worksheet for whatever entry you've done in the hq db - if you're unsure

> > about which worksheet to use, consult the help guide (there is a worksheet

> > summary that explains what different worksheets do) - I would also strongly

> > recommend you hire an experienced rms partner fora day or two of training -

> > especially if headquarters is involved - hope this helps.....

> >

> > "T Parks" wrote:

> >

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