Migration path -> Unidata V6 to DB2 V8.2

[1000101011]

Hello all

A client of ours is using IBM Unidata (U2 product line) V6 and now
wants to migrate away to something more dynamic. When I say dynamic I
mean industry recognized and able to support a development environment
that is specifically .NET and C# orientated.

The current choices that they are looking at are very simple: SQL and
SQL.

Having had a short amount of experience with DB2 V8, I would like to
throw it onto the table as a strong contender(personally I prefer DB2
by a long way to SQL) and I believe I have a strong case for it after
IBM's recent announcement of Unidata being able to write to a DB2
backend database(s).

I believe that there is, or soon will be, a driver that will allow
Unidata to write to a DB2 backend? would this be a good path to
migration, as I guess the normalisation of the data would otherwise be
quite a laborious time consuming exercise (I have never done it). How
difficult is it to get hold of this (the client receives major
releases) and is it possible for me to build a test environment to
evaluate this possibility (using the freely downloadable evaluation
version of DB2 if possible)? Any links to cost comparisons?

The platform they are currently using is Solaris 9 (SPARC), personally
I would quite like to see a comparison on Linux, Solaris and AIX (my
experience is primarily SUN) out of curiosity, I would like to build
these environments myself.

I'd also be quite keen on recommended an application server for them,
though with .NET, this could be difficult away from MS own product
line. I have a short amount of experience with WAS 4/5, does this in
anyway support .NET (other than J2EE)? Obviously WebLogic has limited
support of .NET.

Any tips etc would be greatfully appreciated

Many thanks :)

[Mark A]

"1000101011" <tl******************@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Hello all

A client of ours is using IBM Unidata (U2 product line) V6 and now
wants to migrate away to something more dynamic. When I say dynamic I
mean industry recognized and able to support a development environment
that is specifically .NET and C# orientated.

The current choices that they are looking at are very simple: SQL and
SQL.

Having had a short amount of experience with DB2 V8, I would like to
throw it onto the table as a strong contender(personally I prefer DB2
by a long way to SQL) and I believe I have a strong case for it after
IBM's recent announcement of Unidata being able to write to a DB2
backend database(s).

I believe that there is, or soon will be, a driver that will allow
Unidata to write to a DB2 backend? would this be a good path to
migration, as I guess the normalisation of the data would otherwise be
quite a laborious time consuming exercise (I have never done it). How
difficult is it to get hold of this (the client receives major
releases) and is it possible for me to build a test environment to
evaluate this possibility (using the freely downloadable evaluation
version of DB2 if possible)? Any links to cost comparisons?

The platform they are currently using is Solaris 9 (SPARC), personally
I would quite like to see a comparison on Linux, Solaris and AIX (my
experience is primarily SUN) out of curiosity, I would like to build
these environments myself.

I'd also be quite keen on recommended an application server for them,
though with .NET, this could be difficult away from MS own product
line. I have a short amount of experience with WAS 4/5, does this in
anyway support .NET (other than J2EE)? Obviously WebLogic has limited
support of .NET.

Any tips etc would be greatfully appreciated

Many thanks :)

When you say "SQL" do you mean MS SQL Server? SQL is an interface language
invented by IBM that is common to all relational databases including DB2.

[1000101011]

Hi

Thank you for your reply.

You are correct, my apologies for not being clear, yes I meant
Microsoft SQL Server (32bit), not the interface language.

Thanks

[1000101011]

Ok I just found this:
ftp://ftp.software.ibm.com/software/...comparison.pdf
which is a technical comparison of DB2, SQL and Oracle! Very useful.
Would appreciate any comments to my original post.

Thanks guys

[Larry]

Check this out:

http://www-306.ibm.com/software/data...data/ud71-ann/

Also, DB2 UDB has a high level of integration with .NET .

Larry Edelstein

1000101011 wrote:

Hello all

A client of ours is using IBM Unidata (U2 product line) V6 and now
wants to migrate away to something more dynamic. When I say dynamic I
mean industry recognized and able to support a development environment
that is specifically .NET and C# orientated.

The current choices that they are looking at are very simple: SQL and
SQL.

Having had a short amount of experience with DB2 V8, I would like to
throw it onto the table as a strong contender(personally I prefer DB2
by a long way to SQL) and I believe I have a strong case for it after
IBM's recent announcement of Unidata being able to write to a DB2
backend database(s).

I believe that there is, or soon will be, a driver that will allow
Unidata to write to a DB2 backend? would this be a good path to
migration, as I guess the normalisation of the data would otherwise be
quite a laborious time consuming exercise (I have never done it). How
difficult is it to get hold of this (the client receives major
releases) and is it possible for me to build a test environment to
evaluate this possibility (using the freely downloadable evaluation
version of DB2 if possible)? Any links to cost comparisons?

The platform they are currently using is Solaris 9 (SPARC), personally
I would quite like to see a comparison on Linux, Solaris and AIX (my
experience is primarily SUN) out of curiosity, I would like to build
these environments myself.

I'd also be quite keen on recommended an application server for them,
though with .NET, this could be difficult away from MS own product
line. I have a short amount of experience with WAS 4/5, does this in
anyway support .NET (other than J2EE)? Obviously WebLogic has limited
support of .NET.

Any tips etc would be greatfully appreciated

Many thanks :)

[1000101011]

Hi Larry

Thats excellent, thanks for the link. I am about to go home, but will
have a look there!

Basically I am hoping there is a seamless migration via the External
Database Integration functionality with the new version of UDT V7 -
quickly reading the link you sent me, so that we may move away from it
with minimal porting.