Synchronizing Item DB between POS and backoffice

Posted by Gerd on December 21, 2008, 6:59 pm

Please log in for more thread options

In my backoffice i use a copy of my POS item database. I mainly use it to
print mass labels and to process my online orders. This database is not
connected in any way to the POS database.

What I would like to do is to synchronize the items table between POS and
backoffice. I just would like to get all new or updated items from the POS
maybe once a week, or whenever i know i made changes to the POS items table.

Is there an easy way to get this done? I don't want to just restore an
entire backup as I would loose my online order payment processing.

Both systems are on RMS 2.0 latest support pack.

Posted by Joie on December 22, 2008, 2:49 am

Please log in for more thread options

Mmm,

Is there a reason why you dont install the Store Operations administrator/
manager at back office so that you can connect to the online POS database ?

I am not sure whether there is an easy way to synchronize 2 tables in
database
The hardway would be:
1. export the item table content . i think use a bcp command line utility
that comes with SQL server installation
2. Import back usig the same bcp utility at the target machine

But this would be one way synchronization

rgds,
Joie

> In my backoffice i use a copy of my POS item database. I mainly use it to

> print mass labels and to process my online orders. This database is not

> connected in any way to the POS database.

> What I would like to do is to synchronize the items table between POS and

> backoffice. I just would like to get all new or updated items from the POS

> maybe once a week, or whenever i know i made changes to the POS items

> table.

> Is there an easy way to get this done? I don't want to just restore an

> entire backup as I would loose my online order payment processing.

> Both systems are on RMS 2.0 latest support pack.

Posted by Gerd on December 22, 2008, 8:28 am

Please log in for more thread options

Thanks for your reply, Joie.

I have the SO adminitrator installed on the backoffice system. The main
reason I don't want to connect to the POS database is that all my online
orders are processed in Quickbooks. Only the credit card processing is done
in the backoffice POS.

Every day I extract all the sales and tender details from the POS and load
those into Quickbooks as well. Connecting the backoffice to the POS would
give me wrong tender totals, as for the online orders i would not have the
sales to go with it.

Is the bcp utility also part of store operations or only part of a full SQL
server installation? I only have store operations but not a full SQL server
installed on the backoffice pc.

> Mmm,

> Is there a reason why you dont install the Store Operations administrator/

> manager at back office so that you can connect to the online POS database

> ?

> I am not sure whether there is an easy way to synchronize 2 tables in

> database

> The hardway would be:

> 1. export the item table content . i think use a bcp command line utility

> that comes with SQL server installation

> 2. Import back usig the same bcp utility at the target machine

> But this would be one way synchronization

> rgds,

> Joie

>> In my backoffice i use a copy of my POS item database. I mainly use it to

>> print mass labels and to process my online orders. This database is not

>> connected in any way to the POS database.

>> What I would like to do is to synchronize the items table between POS and

>> backoffice. I just would like to get all new or updated items from the

>> POS maybe once a week, or whenever i know i made changes to the POS items

>> table.

>> Is there an easy way to get this done? I don't want to just restore an

>> entire backup as I would loose my online order payment processing.

>> Both systems are on RMS 2.0 latest support pack.

Posted by Joie on December 22, 2008, 9:14 am

Please log in for more thread options

I am using SQL server 2005 standard edition
On my machine the bcp tool is located at
C:Program FilesMicrosoft SQL Server90ToolsBinn

> Thanks for your reply, Joie.

> I have the SO adminitrator installed on the backoffice system. The main

> reason I don't want to connect to the POS database is that all my online

> orders are processed in Quickbooks. Only the credit card processing is

> done in the backoffice POS.

> Every day I extract all the sales and tender details from the POS and load

> those into Quickbooks as well. Connecting the backoffice to the POS would

> give me wrong tender totals, as for the online orders i would not have the

> sales to go with it.

> Is the bcp utility also part of store operations or only part of a full

> SQL server installation? I only have store operations but not a full SQL

> server installed on the backoffice pc.

>> Mmm,

>> Is there a reason why you dont install the Store Operations

>> administrator/ manager at back office so that you can connect to the

>> online POS database ?

>> I am not sure whether there is an easy way to synchronize 2 tables in

>> database

>> The hardway would be:

>> 1. export the item table content . i think use a bcp command line utility

>> that comes with SQL server installation

>> 2. Import back usig the same bcp utility at the target machine

>> But this would be one way synchronization

>> rgds,

>> Joie

>>> In my backoffice i use a copy of my POS item database. I mainly use it

>>> to print mass labels and to process my online orders. This database is

>>> not connected in any way to the POS database.

>>>

>>> What I would like to do is to synchronize the items table between POS

>>> and backoffice. I just would like to get all new or updated items from

>>> the POS maybe once a week, or whenever i know i made changes to the POS

>>> items table.

>>>

>>> Is there an easy way to get this done? I don't want to just restore an

>>> entire backup as I would loose my online order payment processing.

>>>

>>> Both systems are on RMS 2.0 latest support pack.

Posted by Gerd on December 23, 2008, 7:31 am

Please log in for more thread options

Thanks Joie, I'll check it out.

>I am using SQL server 2005 standard edition

> On my machine the bcp tool is located at

> C:Program FilesMicrosoft SQL Server90ToolsBinn

>> Thanks for your reply, Joie.

>> I have the SO adminitrator installed on the backoffice system. The main

>> reason I don't want to connect to the POS database is that all my online

>> orders are processed in Quickbooks. Only the credit card processing is

>> done in the backoffice POS.

>> Every day I extract all the sales and tender details from the POS and

>> load those into Quickbooks as well. Connecting the backoffice to the POS

>> would give me wrong tender totals, as for the online orders i would not

>> have the sales to go with it.

>> Is the bcp utility also part of store operations or only part of a full

>> SQL server installation? I only have store operations but not a full SQL

>> server installed on the backoffice pc.

>>> Mmm,

>>>

>>> Is there a reason why you dont install the Store Operations

>>> administrator/ manager at back office so that you can connect to the

>>> online POS database ?

>>>

>>> I am not sure whether there is an easy way to synchronize 2 tables in

>>> database

>>> The hardway would be:

>>> 1. export the item table content . i think use a bcp command line

>>> utility that comes with SQL server installation

>>> 2. Import back usig the same bcp utility at the target machine

>>>

>>> But this would be one way synchronization

>>>

>>> rgds,

>>> Joie

>>>

>>>> In my backoffice i use a copy of my POS item database. I mainly use it

>>>> to print mass labels and to process my online orders. This database is

>>>> not connected in any way to the POS database.

>>>>

>>>> What I would like to do is to synchronize the items table between POS

>>>> and backoffice. I just would like to get all new or updated items from

>>>> the POS maybe once a week, or whenever i know i made changes to the POS

>>>> items table.

>>>>

>>>> Is there an easy way to get this done? I don't want to just restore an

>>>> entire backup as I would loose my online order payment processing.

>>>>

>>>> Both systems are on RMS 2.0 latest support pack.

>>>