Logs that are located in <Epicor installation folder>\Server\Logs.
Look in *.server.log files.
Look in *.server.log files.
>The DMT is different. It does not load the tables directly. It calls
> I'm only assuming the DMT is a lot like the tools that have preceded it. I'll apologize ahead of time if I'm mistaken.
>
>it. I'll apologize ahead of time if I'm mistaken.
> Hi Bruce,
>
> >
> > I'm only assuming the DMT is a lot like the tools that have preceded
> >[Non-text portions of this message have been removed]
>
> The DMT is different. It does not load the tables directly. It calls
> the business objects at the .Net level and it can spawn multiple
> processes to keep several appServers busy. Because it uses the BOs, it
> also enforces all business logic.
>
> Mark W.
>
>it. I'll apologize ahead of time if I'm mistaken.
> Hi Bruce,
>
> >
> > I'm only assuming the DMT is a lot like the tools that have preceded
> >This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
> The DMT is different. It does not load the tables directly. It calls
> the business objects at the .Net level and it can spawn multiple
> processes to keep several appServers busy. Because it uses the BOs, it
> also enforces all business logic.
>
> Mark W.
>
--- In vantage@yahoogroups.com, "Moore, Jim (Anniston)" <james.moore@...> wrote:
>
> How did you move your open Jobs? Did you use DMT for this or move them
> manually?
>
> We have around 2000 open jobs and we are trying to figure out the best
> way to move them when we go from 6.1 to 9.x.
>
>
>
> Thanks,
>
> Jim Moore
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Len Hartka
> Sent: Friday, December 03, 2010 3:26 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Data conversion options & Data Migration Tool
>
>
>
>
>
> Good Day Brian:
>
> Sun went live on 11/29
> in Epicor 9, 9.05.601B SQL-Unidata
> Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
>
> We used the DMT tool. I think it is faster then Service-Connect, but
> slower then the other tool (Pervasive?); but DMT does better Data
> checking ( Business logic).
> SQL is immediate, but NO businesslogic checking so cannot be used
> unless you spend many hours "testing" your import files.
>
> Our run time - 24 hours a day - was 3.5 days. 292,000 Part#s,
> 400,000 records in BOM
>
> We broke it up into static ( ran 11/18) and Active data ( ran
> 11/24). Static took 3 days - Active only 0.5 days.
> Active consists of only AdjCost, AdjQty, OpenAR, OpenAP, so between
> 11/18 and 11/24, our old package, M2K ran as normal. Just need to Add
> new Part#'s into LIVE before doing Active pass since some of those new
> parts may have cost or Qty.
> We were lucky in that they did the conversion on our box, so there
> was no sending of files, and I was able to edit the error files and get
> them ready for re-processing.
> DMT tool is about $2,400.
> Also, DMT does not like files over 50,000 records ( runs slower and
> slower), so we had 12 PART files - but that is good because with 8
> processors we could open up 8 sessions of the DMT tool and run at once.
> If you try to manually clean up data, do it early - it takes a LOT
> of time. Some one has to be really motivated to do it. It is difficult
> because the data has to stay live in you current system so if you have
> duplicate Customer#s, both need to stay active.
>
> There was one option we did not try. To migrate, the Part-master is
> four files. Part, PartRev, PartWhse, and PartPlant - each with 292,000
> records. There is a DMT template for 9.04 ( not 9.05) that does all four
> files at once and is a lot faster. Rumor had it that they were working
> on a 9.05 version.
>
> Don't loose tack of Part Pricelists, and Quotes from Vendors for
> parts.
>
> We went from M2K 9 manage 2000) to 9.05.601B. Transition from V6
> might be smoother since db is more similar.
> Do they still have to convert 6.01 to 9.04 first, then 9.05?
>
> Biggest delay was that once it starts to run you have to be resdy to
> fix the "Reprocess" files ( which are csv files with the records that
> did not load) because you have to finish one set before beginning the
> next. Since we needed to run 24 hours a day, errors had to be fixed as
> soon as they occured - if you wait until morning, you will loose 8 hours
> of run time.
>
> Feek free to call
>
> len.hartka@... <mailto:len.hartka%40sunautomation.com>
> Leonard C. Hartka, IT Director\ERP Manager
> Sun Automation Group
> 66 Loveton Circle
> Sparks, Md. 21152
> 410-329-3560 ext. 120
> 410-329-3564 FAX
> 443-255-7192 Work Cell
> len.hartka@... <mailto:len.hartka%40sunautomation.com>
>
> www.Sunautomation.com <http://www.sunautomation.com/>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Brian Roberts
> Sent: Friday, December 03, 2010 3:34 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Data conversion options & Data Migration Tool
>
> We are currently on Vantage 6.1, and planning an upgrade to Epicor 9.05
> MSSQL. I have some questions about the data conversion process...
>
> We hired Epicor & a consultant to convert our database by running
> through all the various upgrades then the Progress -> MSSQL conversion.
> A test conversion done this way worked very well, but took forever.
> We're looking a live conversion of 4 days of downtime, and are
> struggling with planning this time. For example, we have certain
> shipment timeframes we must meet, our shipping process requires Vantage,
> volume is 50-60 orders/day, and double entering transactions after the
> conversion is done raises a bunch of concerns. Has anybody gone through
> this much conversion downtime or double entry and could offer any
> advice?
>
> Another option suggested by our consultant is the Data Migration Tool
> from Epicor. Reviewing the limited documentation available, it appears
> to only come with templates for 60-ish tables, and any additional ones
> are custom work. (Don't have the tool yet, or even a quote for it yet).
> Has anybody used this tool & your opinion?
>
> We are also looking at purging data in Vantage 6, to reduce the database
> size & thus conversion time. We have never used the "Database Purge &
> Summarize" utility in Vantage, and our consultant also suggested they
> could do custom purging of tables not touched by the standard purge. We
> have approx 5 years of historical data, and could probably purge
> everything more than 18 months old. For anybody that has done purging,
> has this made a big difference?
>
> Any other options to consider?
>
> Vantage 6 database size is 3GB, and the converted Epicor 9 MSSQL
> database is 14.5GB. 40 office users & 30 MES stations.
>
> Thanks,
>
> Brian Roberts
>
> Business Systems Analyst
>
> Ground Effects Ltd
>
> [Non-text portions of this message have been removed]
>
> This e-mail and any attachments may contain proprietary and/or
> confidential information. If you are not the intended recipient, please
> notify the sender immediately by reply e-mail or at 410-472-2900 and
> then delete the message without using, disseminating, or copying this
> message or any portion thereof. With e-mail communications you are urged
> to protect against viruses.
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
--- In vantage@yahoogroups.com, "Robert Jessop" <rjj@...> wrote:
>
> I recently purchased DMT to assist in our conversion from Avante to E9. I am getting an error when it run stating "Unknown error - see appserver logs". Not sure what log it is talking about. Has anyone else seen this error.
>
> Thanks in advance,
>
> Bob Jessop
> Misonix Inc.
>