Sorry for the Delay in the response.
There are several parts that need to be in place.
1) Progress 4gl file that exports the data.
This is what the .p file looks like. Notice that I have selected to only export the fields I need. This will save allot of time and disk space.
DEFINE VARIABLE ProgName AS CHARACTER NO-UNDO.
DEFINE VARIABLE ProgOption AS CHARACTER NO-UNDO.
DEFINE VARIABLE hInstanceNum AS INTEGER NO-UNDO.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\OrderHed.txt BINARY NO-CONVERT.
FOR EACH OrderHed:
EXPORT DELIMITER "~011" OrderHed.ordernum Orderhed.custnum NO-LOCK.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\Part.txt BINARY NO-CONVERT.
FOR EACH Part:
EXPORT DELIMITER "~011" Part.PartNum NO-LOCK.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\RMAHead.txt BINARY NO-CONVERT.
FOR EACH RMAHead:
EXPORT DELIMITER "~011" RMAHead.RMANum.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\JobHead.txt BINARY NO-CONVERT.
FOR EACH JobHead:
EXPORT DELIMITER "~011" JobHead.JobNum Jobhead.Partnum.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\Customer.txt BINARY NO-CONVERT.
FOR EACH Customer:
EXPORT DELIMITER "~011" Customer.CustNum Customer.NAME.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\Vendor.txt BINARY NO-CONVERT.
FOR EACH Vendor:
EXPORT DELIMITER "~011" Vendor.Vendornum Vendor.NAME.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\POHead.txt BINARY NO-CONVERT.
FOR EACH POHead:
EXPORT DELIMITER "~011" POHead.PONum POHead.Vendornum.
END.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\APInvHed.txt BINARY NO-CONVERT.
FOR EACH APInvHed:
EXPORT DELIMITER "~011" APInvHed.VendorNum APInvHed.InvoiceNum.
END.
OUTPUT CLOSE.
2) Setup tables in SQL Server to import the data exported in step one. I prefixed all of mine with PUB_ so that I know when I see dbo.PUB_TableName that its one of the tables I have brought over from progress.
3) Setup your SQL Server Transformation package and schedule it. If you don't know how to do this, I can export a copy of ours from SQL Server and email it to you. You would then just have to import it into SQL Server. You shouldn't have a problem setting them up.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Saturday, November 01, 2003 1:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] What database?
Well, I guess MS-SQL sounds like it is out of the question where Vantage
is concerned.
Too bad, I think it's a great general purpose DB for a company of our
size.
Maybe not the fastest or most powerful, but really easy to use, lots of
functionality, etc..
I'll take everybody's word for it that Progress is faster.
I'm certainly not impressed with Progress from what I've seen so far.
Hopefully by the time Sonoma matures I'll be able to dump it and use
MS-SQL instead.
Or maybe Epicor and Progress will begin to provide some of the nice
tools that I've come to expect as standard.
Anyway.. I find it is nice to have a few web pages on out Intranet with
data from our DB.
Nothing fancy, just reading data and displaying it in a web page.
I don't see any reason to buy some expensive bloated web enabling
package just for my limited needs.
Jeremy,
Do you mind giving me some of the details for the mechanics of your
setup?
Thanks,
Bruce Ordway
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Friday, October 31, 2003 6:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] What database?
We not only noticed a decrease in speed but several off the wall errors
that effected us for some time. The Priority Dispatch report went from 2
min to 40 min to run. Epicor said there was nothing they planned on
doing about it. They said it was normal for a screen to take 3 min to
open. I think the first time we ran capture it took 6 hours. We tried
several times to run Global Finite Scheduling but after about 24 hours
of running it would balm out. It normally would take us about an hour
to run. When we would call Tech Support and tell them we used SQL
Server you could hear the dread in their voices. When we upgrade to 5.1
and Progress 9.1C the speed got better but Epicor had no clue how the
database was supposed to be setup. Half the company couldn't get into
Vantage for 3 days. Since I wasn't getting anywhere with Epicor I went
to Progress who of course tried to send me back to Epicor. I told them
I wasn't getting the help I need and Progress did help us. After about
15 min on the phone with a Progress tech support guy everything was back
up and running. This told me Epicor had never tested 5.1 in a live
environment because the changes to the setup was so different then what
it used to be in 5.0. This was over 18 months ago and maybe things have
gotten better. What really made me mad was just after that I went to
the Epicor conference in Orlando and listened to them brag about Vantage
running on SQL Server. It would take allot for use to ever consider
switching back. I really like SQL Server and we do run if for every
other database but Vantage. I setup an SQL Server local data
transformation package. It exports the tables from Progress into text
files and then imports them into SQL Server. It was easy enough to
setup and runs fast. We run it every half hour. It works well for most
reports. Let us know if you go with SQL Server and how well it does
for you. They may have fixed most of it.
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Friday, October 31, 2003 12:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] What database?
really the database?
A LOT of people use MS-SQL.
I would have thought it a natural for mid-sized companies.
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/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
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/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
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/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
There are several parts that need to be in place.
1) Progress 4gl file that exports the data.
This is what the .p file looks like. Notice that I have selected to only export the fields I need. This will save allot of time and disk space.
DEFINE VARIABLE ProgName AS CHARACTER NO-UNDO.
DEFINE VARIABLE ProgOption AS CHARACTER NO-UNDO.
DEFINE VARIABLE hInstanceNum AS INTEGER NO-UNDO.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\OrderHed.txt BINARY NO-CONVERT.
FOR EACH OrderHed:
EXPORT DELIMITER "~011" OrderHed.ordernum Orderhed.custnum NO-LOCK.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\Part.txt BINARY NO-CONVERT.
FOR EACH Part:
EXPORT DELIMITER "~011" Part.PartNum NO-LOCK.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\RMAHead.txt BINARY NO-CONVERT.
FOR EACH RMAHead:
EXPORT DELIMITER "~011" RMAHead.RMANum.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\JobHead.txt BINARY NO-CONVERT.
FOR EACH JobHead:
EXPORT DELIMITER "~011" JobHead.JobNum Jobhead.Partnum.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\Customer.txt BINARY NO-CONVERT.
FOR EACH Customer:
EXPORT DELIMITER "~011" Customer.CustNum Customer.NAME.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\Vendor.txt BINARY NO-CONVERT.
FOR EACH Vendor:
EXPORT DELIMITER "~011" Vendor.Vendornum Vendor.NAME.
END.
OUTPUT CLOSE.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\POHead.txt BINARY NO-CONVERT.
FOR EACH POHead:
EXPORT DELIMITER "~011" POHead.PONum POHead.Vendornum.
END.
OUTPUT TO v:\mfgsys\ud\sqlexport\data\APInvHed.txt BINARY NO-CONVERT.
FOR EACH APInvHed:
EXPORT DELIMITER "~011" APInvHed.VendorNum APInvHed.InvoiceNum.
END.
OUTPUT CLOSE.
2) Setup tables in SQL Server to import the data exported in step one. I prefixed all of mine with PUB_ so that I know when I see dbo.PUB_TableName that its one of the tables I have brought over from progress.
3) Setup your SQL Server Transformation package and schedule it. If you don't know how to do this, I can export a copy of ours from SQL Server and email it to you. You would then just have to import it into SQL Server. You shouldn't have a problem setting them up.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Saturday, November 01, 2003 1:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] What database?
Well, I guess MS-SQL sounds like it is out of the question where Vantage
is concerned.
Too bad, I think it's a great general purpose DB for a company of our
size.
Maybe not the fastest or most powerful, but really easy to use, lots of
functionality, etc..
I'll take everybody's word for it that Progress is faster.
I'm certainly not impressed with Progress from what I've seen so far.
Hopefully by the time Sonoma matures I'll be able to dump it and use
MS-SQL instead.
Or maybe Epicor and Progress will begin to provide some of the nice
tools that I've come to expect as standard.
Anyway.. I find it is nice to have a few web pages on out Intranet with
data from our DB.
Nothing fancy, just reading data and displaying it in a web page.
I don't see any reason to buy some expensive bloated web enabling
package just for my limited needs.
Jeremy,
>I setup an SQL Server local data transformation package.<This sounds like it might do the trick for me.
> It exports the tables from Progress into text files and then imports<
> them into SQL Server. It was easy enough to setup and runs fast.<
> We run it every half hour. It works well for most reports.<
Do you mind giving me some of the details for the mechanics of your
setup?
Thanks,
Bruce Ordway
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Friday, October 31, 2003 6:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] What database?
We not only noticed a decrease in speed but several off the wall errors
that effected us for some time. The Priority Dispatch report went from 2
min to 40 min to run. Epicor said there was nothing they planned on
doing about it. They said it was normal for a screen to take 3 min to
open. I think the first time we ran capture it took 6 hours. We tried
several times to run Global Finite Scheduling but after about 24 hours
of running it would balm out. It normally would take us about an hour
to run. When we would call Tech Support and tell them we used SQL
Server you could hear the dread in their voices. When we upgrade to 5.1
and Progress 9.1C the speed got better but Epicor had no clue how the
database was supposed to be setup. Half the company couldn't get into
Vantage for 3 days. Since I wasn't getting anywhere with Epicor I went
to Progress who of course tried to send me back to Epicor. I told them
I wasn't getting the help I need and Progress did help us. After about
15 min on the phone with a Progress tech support guy everything was back
up and running. This told me Epicor had never tested 5.1 in a live
environment because the changes to the setup was so different then what
it used to be in 5.0. This was over 18 months ago and maybe things have
gotten better. What really made me mad was just after that I went to
the Epicor conference in Orlando and listened to them brag about Vantage
running on SQL Server. It would take allot for use to ever consider
switching back. I really like SQL Server and we do run if for every
other database but Vantage. I setup an SQL Server local data
transformation package. It exports the tables from Progress into text
files and then imports them into SQL Server. It was easy enough to
setup and runs fast. We run it every half hour. It works well for most
reports. Let us know if you go with SQL Server and how well it does
for you. They may have fixed most of it.
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Friday, October 31, 2003 12:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] What database?
>it was bad enough to switch back...<Do you think it is because of the way Vantage is constructed or is it
really the database?
A LOT of people use MS-SQL.
I would have thought it a natural for mid-sized companies.
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/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
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/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
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/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/