Re: Migration of databases from MS SQL 6.5 / WinNT to DB2 / AIX (Unix)

Article View: bit.databases.mssql-l

Article #157

Back to bit.databases.mssql-l Previous Next

#157

From: Messi
Date: Fri, 23 Feb 2001 18:33

32 lines
2543 bytes

I have not a lot of experience with AIX, but I can tell you: if you are new
to MSSQL and DB/2 you'll have a hard time. The databases have inherent
differences, and I often see the ones who consider themselves "pros" (and I
really think they are) struggle with this. It gets even much more difficult
if stored procedures are involved.
I wouldn't try to do this without the help of a at least somewhat
experienced DB/2 and MSSQL DBA or developer, especially because he knows the
pitfalls. The problem is: After some reading etc. you'll be able to migrate
them, but it could be that, when going to production, the system fails. Have
a nice time then! So you should consult one who knows what can happen etc.

just my 2 cents of course, but I think such a task is too important to "just
try it"

Messi

"David" <david.turk@siol.net> wrote in message
news:uodl6.1756$Q8.79729@news.siol.net...
> Hello
>
> I'm relatively new to DB 2 and MS SQL.
> I have to move database from MS SQL 6.5 running on WinNT to IBM DB2 6.1
> running on AIX (Unix).
> If any body has done this before or has any ideas they would be most
> appreciated.
>
> Thanks in advance
>
> David from Slovenia
>
>
>

Technical Details

Message-ID: <c2yl6.71268$GC5.2544881@news.chello.at>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!npeer.kpnqwest.net!nmaster.kpnqwest.net!newsfeed.Austria.EU.net!newsfeed.kpnqwest.at!newsrouter.chello.at!news.chello.at!not-for-mail

References: <uodl6.1756$Q8.79729@news.siol.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115df1,580e0bbaa6dc41a4
X-Google-Attributes: gid115df1,public
X-Google-Thread: f6611,580e0bbaa6dc41a4
X-Google-Attributes: gidf6611,public
X-Google-Thread: 115614,580e0bbaa6dc41a4
X-Google-Attributes: gid115614,public
X-Google-ArrivalTime: 2001-02-23 10:34:18 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!npeer.kpnqwest.net!nmaster.kpnqwest.net!newsfeed.Austria.EU.net!newsfeed.kpnqwest.at!newsrouter.chello.at!news.chello.at!not-for-mail
From: "Messi" <messi@chello.at>
Newsgroups: bit.databases.mssql-l,comp.unix.aix,microsoft.public.sqlserver.odbc
References: <uodl6.1756$Q8.79729@news.siol.net>
Subject: Re: Migration of databases from MS SQL 6.5 / WinNT to DB2 / AIX (Unix)
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <c2yl6.71268$GC5.2544881@news.chello.at>
Date: Fri, 23 Feb 2001 18:33:44 GMT
NNTP-Posting-Host: 212.186.93.213
X-Complaints-To: abuse@news.chello.at
X-Trace: news.chello.at 982953224 212.186.93.213 (Fri, 23 Feb 2001 19:33:44 MET)
NNTP-Posting-Date: Fri, 23 Feb 2001 19:33:44 MET
Organization: Customers chello Austria

Reply to Parent Message