Oninit cdi / Archive
Talk to an expert →

Re: Migration question

Posted in 2000

Topics: Triggers, Constraints & Referential Integrity, Migration, Import/Export & Data Conversion

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

From: "Clifton M. Bean" <cmbean@home.com> > >If you have a preprocessor that can read your dbschema output file, you >will >have all of those items. If the triggers need to be in a separate file, >you >can edit your dbschema output file and move those items to a separate >filename. > >"kevin himmler" <kevin@compu-mentor.net> wrote in message >news:7CFD5CF4E86F4650.0C704220B474A34F.53711F0DADD8C3AC@lp.airnews.net... > > How can I be sure that all the triggers, contraints, indexes, and > > scripts will be moved when I migrate to MSSQL if I use the the import > > data feature in SQL? Will I have to read the scripts off of informix and > > manually create them in SQL? But the important question is why would you want to do this? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

↪ replying to Obnoxio The Clown
Clifton M. Bean — — source: Informix-list mailing list archive (1991-1998)

I know nada about the MS import feature. I was taking a stab at the question in an attempt to assist. I am not even sure if that feature can use the Informix DBEXPORT data and sql files. Clifton "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:8f432n$d6s$1@news.xmission.com... > > From: "Clifton M. Bean" <cmbean@home.com> > > > >If you have a preprocessor that can read your dbschema output file, you > >will > >have all of those items. If the triggers need to be in a separate file, > >you > >can edit your dbschema output file and move those items to a separate > >filename. > > > >"kevin himmler" <kevin@compu-mentor.net> wrote in message > >news:7CFD5CF4E86F4650.0C704220B474A34F.53711F0DADD8C3AC@lp.airnews.net... > > > How can I be sure that all the triggers, contraints, indexes, and > > > scripts will be moved when I migrate to MSSQL if I use the the import > > > data feature in SQL? Will I have to read the scripts off of informix and > > > manually create them in SQL? > > But the important question is why would you want to do this? > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >