SEO

#1 (**permalink**) 04-20-2008, 03:22 PM

hi,

i should migrate one informix db on a mssql server 2005,

any ideas how this goes short and efficient?

second problem, also stored procedures must migrate von informix db t
mssql server 2005, is there a way?

one more question, where does informix store the stored procedures o
the sco - unix machine?

thx thx

grizze

--
grizze
-----------------------------------------------------------------------
grizzel's Profile: http://unixadmintalk.com/142
View this thread: svc doesn't stay enabled

#2 (**permalink**) 04-20-2008, 03:22 PM

On Mar 16, 5:47 am, grizzel <helmut.ha...@gmx.net> wrote:
> hi,
>
> i should migrate one informix db on a mssql server 2005,
>
> any ideas how this goes short and efficient?
>
> second problem, also stored procedures must migrate von informix db to
> mssql server 2005, is there a way?
>
> one more question, where does informix store the stored procedures on
> the sco - unix machine?
>
> thx thx
>
> grizzel
>
> --
> grizzel
> ------------------------------------------------------------------------
> grizzel's Profile:http://unixadmintalk.com/1424
> View this thread:file system configuration

You can get the info from looking up or downloading and reading the
documentation on stored procedures and triggers.

We have a SCO 5 machine with an older informix (5 ). Basically, It
stores them in sysprocbody . It may not work on your system but here
is a sql that shows content of stored procedures.
select * from sysprocbody where datakey = "T"
order by procid, seqno

it will show the proc id and procedure code.

#3 (**permalink**) 04-20-2008, 03:23 PM

i should not be doing this....

have a look at dbexport and dbschema.

Superboer.

Stick with informix..... its better.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

migrate informix db on mssql server 2005