Skip to content

Clarion dictionary (DCT) to SQL DDL for several back ends.

License

Notifications You must be signed in to change notification settings

samirss56/DCT2SQL

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Development

IF you want me to continue improving this SQL DLL code generator, THEN e-mail me that you are using DCT2SQL. It might be useful to include your use case scenario for DCT2SQL and a description of how it helps the Return On Investment (ROI) of the business you are involved in working. After all is said and done, information technology is there to support the business goals. And the translation of business goals to automation with information technology is our job.

SI desea que continúe mejorando este generador de código DLL SQL, ENTONCES envíeme un correo electrónico indicando que está utilizando DCT2SQL. Podría ser útil incluir el escenario de su caso de uso para DCT2SQL y una descripción de cómo ayuda al retorno de la inversión (ROI) de la empresa en la que está involucrado. Después de todo lo dicho y hecho, la tecnología de la información está ahí para respaldar los objetivos comerciales. Y la traducción de los objetivos comerciales a la automatización con tecnología de la información es nuestro trabajo.

DCT2SQL: SQL DDL Code Generator (Generador de código SQL DDL)

Clarion dictionary to SQL DDL back end code generation templates.

This will take a clarion dictionary (DCT) and create SQL DDL code for several SQL back ends.

The WIKI for this repository has a DCT2SQL documentation area. There is a ToDo list for conversion that might come in handy when you do this task.

The current SQL back ends can have DDL template generated code are:

POSTGRESQL, MYSQL, MSSQL, SQLANYWHERE, and MIMER.

The dictionaries should be SQL ready to be generated correctly and there are a number of audit templates to help you check and correct your dictionary.

The UTILITY templates have documentation built in that shows on the screen. Documentation is updated and improved on a regular basis. And since these templates only create output text files, they do not cause any changes to your existing systems and operations.

Conversion of DATA from ISAM to SQL (Conversión de datos de ISAM a SQL)

The DCT2SQL templates do not handle conversion of the data in your ISAM files. The additional task where you have to create procedures to output all your table's data as a CSV file is done by the DUMPLOAD backup code generator. You will still have to create the SQL server table LOAD query script. That is dependent on your SQL server and you will have to build that QUERY yourself.

Las plantillas DCT2SQL no controlan la conversión de los datos en sus archivos ISAM. La tarea adicional en la que tienes que crear procedimientos para generar todos los datos de tu tabla como un archivo CSV la realiza el generador de código de reserva DUMPLOAD. Aún tendrá que crear el script de consulta LOAD de la tabla del servidor SQL. Eso depende de tu SQL servidor y tendrá que construir esa CONSULTA usted mismo.

Webinars explaining how to use the DCT2SQL templates

ClarionLive: 474 : Aug 03, 2018 : http://www.mediafire.com/file/pm53isb5f3lcquc/DCT2SQL_20180714_A1109.zip

ClarionLive: 560 : May 01, 2020 : https://www.youtube.com/watch?v=bAolfvrz2oE&feature=youtu.be

ClarionLive: 579 : Sep 11, 2020 : https://www.youtube.com/watch?v=ZK4p6CGoOBo&feature=youtu.be

Clarioneros : 164 : 2020-09-12 : https://clarionlive.com/clarioneros.htm (OneDrive link)

Let me know about your conversion

Please, if you use the DCT2SQL for your conversion project, then send me an email just letting me know what type of conversion you did, and how you have used them. It would be appreciated. Thank you in advance.

Code Wiki Main Repositories

About

Clarion dictionary (DCT) to SQL DDL for several back ends.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Clarion 95.1%
  • Smarty 4.9%