JDE VB Program Convert Fields to SQL Server
Download. There's a VB zip file (very small) and a large
MDB zip file. You can download them individually. The .MDB file has already-converted file
and field names. You'll need to manually upload them to SQL server, but only if you want
to. The program allows you to type in new field and file names and automatically change
them in SQL server.
This application has NOT been made commercial friendly. You'll see references to JANUS
(That's our SQL Server DB, and SP_NT2, etc (our NT Server) You'll have to figure out how
to adapt them to your own environment (see the Notes.TXT file for some help)
| We use this application to constuct the (MS) SQL statements for
retrieveing AS/400 field names, like F42119.SDAEXP, F4211.SDAOQS from Netsoft downloads.
We convert the field names to SQL server field names (contained in the JDE data
dictionary, we'll tell you which files, there are several), update that field name to
conform to our naming conventions if we want, and create the SQL format file and the BCP
file. Convert JDE Fields to SQL Server is a tremendous time saver in constructing the
format file and BCP file. It only takes a few seconds to run.
JDE and JD Edwards are copyrights of JD Edwards Inc, All rights reserved. MiniSolve has
no affililiation with JD Edwards, either stated or implied. JD Edwards does not know
anything about these programs, so please don't contact them.
Back to Mini Solve Products and more Tips
|
|
