Merging sales data .bck file with current sales data??

Posted by PRJ on June 1, 2007, 3:59 pm

Please log in for more thread options

In a post below ("Sales Data .bck file.....") Jeff @ Checkpoint Software
responded that there WAS a way to merge the older sales history in a saved
.bck file with the recent sales data currently in RMS. I am working with an
RMS tech (not the one who was invovled in the lost data problem) and he does
not believe there's a way to merge the data. If there IS, I would really
appreciate some guidance.

Briefly..... We currently only have a few weeks of sales data in our RMS
data base on our server, have definitely lost the 3 months prior to that BUT
think we have a saved .bck file of the 12 months prior to the lost months.

We need to know at least 2 things:

1. How to find out what is really in the .bck file that we think contains a
year's sales data.
2. If it IS the data we need...... how to merge it with the data currently
being compiled in RMS.

This is a real mess for us and we'd be grateful for any suggestions.

--
WineGuy

Posted by Akber Alwani on June 2, 2007, 4:08 am

Please log in for more thread options

Your answer are as follows:
1. The way you can do so is that in the from the last backup restore as new
database name to any. and in the SO configuration use the new restore
database and then use the SO Manager program to see what is in.
2. Merging is possible but is not easy as you specified I can give you idea :
Database A (the current database)
Database B (the restore database created with new name)

you can use the insert statements to insert the data in Transaction,
TransactionEntry, TenderEntry, Journal etc. I think the MS tech who is near
to you help you out in this but if you let me know what information you are
really interested in so I can prepare the script and send it to you.

"PRJ" wrote:

> In a post below ("Sales Data .bck file.....") Jeff @ Checkpoint Software

> responded that there WAS a way to merge the older sales history in a saved

> .bck file with the recent sales data currently in RMS. I am working with an

> RMS tech (not the one who was invovled in the lost data problem) and he does

> not believe there's a way to merge the data. If there IS, I would really

> appreciate some guidance.

> Briefly..... We currently only have a few weeks of sales data in our RMS

> data base on our server, have definitely lost the 3 months prior to that BUT

> think we have a saved .bck file of the 12 months prior to the lost months.

> We need to know at least 2 things:

> 1. How to find out what is really in the .bck file that we think contains a

> year's sales data.

> 2. If it IS the data we need...... how to merge it with the data currently

> being compiled in RMS.

> This is a real mess for us and we'd be grateful for any suggestions.

> --

> WineGuy

Posted by Jeff @ Check Point Software on June 7, 2007, 1:18 am

Please log in for more thread options

: quoted-printable

WineGuy,

Restore the bck file on your server and see what you've got.

If you have been running in Offline mode. Just install your 3 month old =
version on the server and connect to it. POS should sync to the old =
version and all you would be missing is the in-between stuff.

Backup both databases First!!

Otherwise, your reseller will have to do some merging of the tables. If =
they aren't _real_ confident they can do it, let MS do it for you @ $175 =
per hour, 1 hour minimum. I wouldn't think it would take them more than =
2 hours at worst.

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

In a post below ("Sales Data .bck file.....") Jeff @ Checkpoint =
Software=20
responded that there WAS a way to merge the older sales history in a =
saved=20
.bck file with the recent sales data currently in RMS. I am working =
with an=20
RMS tech (not the one who was invovled in the lost data problem) and =
he does=20
not believe there's a way to merge the data. If there IS, I would =
really=20
appreciate some guidance.

Briefly..... We currently only have a few weeks of sales data in our =
RMS=20
data base on our server, have definitely lost the 3 months prior to =
that BUT=20
think we have a saved .bck file of the 12 months prior to the lost =
months.

We need to know at least 2 things:

1. How to find out what is really in the .bck file that we think =
contains a=20
year's sales data. =20
2. If it IS the data we need...... how to merge it with the data =
currently=20
being compiled in RMS.

This is a real mess for us and we'd be grateful for any suggestions.

--=20
WineGuy
------=_NextPart_000_01D4_01C7A888.97889DC0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.6000.16441" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>WineGuy,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Restore the bck file on your server and see =
what you've=20
got.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>If you have been running in Offline mode. =
Just install=20
your 3 month old version on the server and connect to it.  POS =
should sync=20
to the old version and all you would be missing is the in-between=20
stuff.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Backup both databases First!!</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Otherwise, your reseller will have to do some =
merging=20
of the tables.  If they aren't _real_ confident they can do it, let =
MS do=20
it for you @ $175 per hour, 1 hour minimum.  I wouldn't think it =
would take=20
them more than 2 hours at worst.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).  If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"PRJ" <<A=20
=
om</A>>=20
wrote in message <A=20
=
BDCF0-1CC9-4B2E-9F98-5AA6C8C93677@microsoft.com</A>...</DIV>In=20
a post below ("Sales Data .bck file.....") Jeff @ Checkpoint Software=20
<BR>responded that there WAS a way to merge the older sales history in =
a saved=20
<BR>.bck file with the recent sales data currently in RMS.  I am =
working=20
with an <BR>RMS tech (not the one who was invovled in the lost data =
problem)=20
and he does <BR>not believe there's a way to merge the data.  If =
there=20
IS, I would really <BR>appreciate some guidance.<BR><BR>Briefly..... =
We=20
currently only have a few weeks of sales data in our RMS <BR>data base =
on our=20
server, have definitely lost the 3 months prior to that BUT <BR>think =
we have=20
a saved .bck file of the 12 months prior to the lost months.<BR><BR>We =
need to=20
know at least 2 things:<BR><BR>1.  How to find out what is really =
in the=20
.bck file that we think contains a <BR>year's sales data.  =
<BR>2. =20
If it IS the data we need...... how to merge it with the data =
currently=20
<BR>being compiled in RMS.<BR><BR><BR>This is a real mess for us and =
we'd be=20
grateful for any suggestions.<BR><BR>-- =
<BR>WineGuy</BLOCKQUOTE></BODY></HTML>

------=