Re: convert dds to ddl

[Paul Tuohy <tuohyp@xxxxxxxxxxxxxxxxx>]

Hi Gerald,

I was just recommending the free analysis tool which will highlight any 
potential problems.
As to whether or not a tool like XCase is required is a pure business 
decision.

Regards

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





Gqcy wrote:
> Thanks Paul,
>
> I tested the xCase tool the other day.
>
> It was a lot beefier than I wanted.
>
> -gerald
>
>
>
>
>
>
>
> Paul Tuohy wrote:
>   
> > 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
> > >
> > >
> > >   
> > >