MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » August 2010

Re: convert dds to ddl



fixed

Before doing the conversion I recommend you have a look at the free XCase Diagnostic tool which will give you an analsis of your database and any potential conversion problems
http://www.xcaseforsystemi.com/index.php?option=com_content&task=view&id=47&Itemid=79 <http://www.xcaseforsystemi.com/index.php?option=com_content&task=view&id=47&Itemid=79>

I have no affiliation with XCase

Regards

Paul Tuohy
ComCon
www.comconadvisor.com www.systemideveloper.com




Gqcy wrote:
I have been doing some reading, and I am ready to create a procedure for us to convert our database from dds to ddl. (making sure level id's are protected)
http://wiki.midrange.com/index.php/Sql_convert_from_dds



some questions:

we are at 6.1. is there a benefit to wait for 7.1?


I know I can add field alias, change column text, and field text.
what else can/should I put in the SQL, without changing the level id?

I will create new SQL indexes prior to re-creating my old logicals.
what else can/should I do to my logicals?


Thanks so much.

gerald







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact