Upgrading from PROGRESS TO SQL

Yahoo Archive
1
It's a pretty big process, but manageable with the right assistance.

I have completed several of these and the problems have varied each time.
Usually there are field size problems, index key problems and other random
things. The learning curve was kind of rough and annoying, but after getting
several done it's much smoother from my point of view.

One thing you should keep in mind if you ever decide to make the change, do
it separate from an upgrade, it makes it easier to separate out the cause of
any errors, easier to figure out if it's just an upgrade problem or an SQL
conversion problem instead of sorting both out at the same time.

Estimated time is usually 48 hours for an initial conversion to spend time
sorting out all the problems of the SQL conversion, and then any interim
ones are usually much less time because the issues are usually all sorted
out in the initial conversion and it's just running through the process.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Dina Hieber
Sent: Wednesday, December 19, 2012 1:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Upgrading from PROGRESS TO SQL

Hi Everyone. We are in the process of implementing E9. We have started
the implementation using Progress. Say 5 years from now, we decide we
would want to go the SQL, does anyone know what the data conversion would be
like?


Best Regards,

Dina M. Hieber
Vamco International, Inc.
555 Epsilon Drive
Pittsburgh, PA 15238

(412) 963-7100 x 203
(412) 963-9511

www.vamcointernational.com<http://www.vamcointernational.com>

*****
This e-mail message and any files transmitted with it are confidential and
are intended for the sole use of the intended receipient(s). Any
unauthorized use or disclosure is prohibited. Any opinions express in the
email are those of the individual and not necessarily the company. If you
are not the intended recipient, please contact the send by reply email and
destroy all copies of the original message.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Karen Schoenung
Sent: Wednesday, December 19, 2012 1:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple BAQ assistance



I would think using the Invoice Header, Invoice Detail and Ship Header and
Ship Detail should get you the information (your lots are on the shipments -
correct?)

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of jb_in_wi
Sent: Wednesday, December 19, 2012 8:32 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Simple BAQ assistance

I'm not a programmer, but can do simple BAQ's, or so I thought. I'm trying
to run a BAQ that will tell me what invoice is associated with each lot
number, but I haven't been able to find the correct way to link the tables
they are in...anyone have a suggestion--or better yet, an answer? Would be
appreciated.
9.04.506c

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
Hi Everyone. We are in the process of implementing E9. We have started the implementation using Progress. Say 5 years from now, we decide we would want to go the SQL, does anyone know what the data conversion would be like?


Best Regards,

Dina M. Hieber
Vamco International, Inc.
555 Epsilon Drive
Pittsburgh, PA 15238

(412) 963-7100 x 203
(412) 963-9511

www.vamcointernational.com<http://www.vamcointernational.com>

*****
This e-mail message and any files transmitted with it are confidential and are intended for the sole use of the intended receipient(s). Any unauthorized use or disclosure is prohibited. Any opinions express in the email are those of the individual and not necessarily the company. If you are not the intended recipient, please contact the send by reply email and destroy all copies of the original message.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Karen Schoenung
Sent: Wednesday, December 19, 2012 1:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Simple BAQ assistance



I would think using the Invoice Header, Invoice Detail and Ship Header and Ship Detail should get you the information (your lots are on the shipments - correct?)

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of jb_in_wi
Sent: Wednesday, December 19, 2012 8:32 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Simple BAQ assistance

I'm not a programmer, but can do simple BAQ's, or so I thought. I'm trying to run a BAQ that will tell me what invoice is associated with each lot number, but I haven't been able to find the correct way to link the tables they are in...anyone have a suggestion--or better yet, an answer? Would be appreciated.
9.04.506c

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]