Professional Web Applications Themes

migration from MS Sqlserver 2000 to Linux/UDB 8.1 - IBM DB2

"Murty" <adavicomcast.net> wrote in message news:QZ%Ua.162550$ye4.109475sccrnsc01... > My company has decided to convert a Windows 2000 / MS Sql server app to > Linux/DB2-UDB8.1. > The original SQL server app has got about 350 tables & 1200 stored procs and > no proper doentation > exists. I am not sure whether UDB 8.1 has got full support for SQL stored > procs (I know that atleast 7.x > doesn't support SQL stored procs). A number of stored procs have got > references to objects in MSDB database > of SQL server. > What do you think are the possible issues ...

  1. #1

    Default Re: migration from MS Sqlserver 2000 to Linux/UDB 8.1

    "Murty" <adavicomcast.net> wrote in message
    news:QZ%Ua.162550$ye4.109475sccrnsc01...
    > My company has decided to convert a Windows 2000 / MS Sql server app to
    > Linux/DB2-UDB8.1.
    > The original SQL server app has got about 350 tables & 1200 stored procs
    and
    > no proper doentation
    > exists. I am not sure whether UDB 8.1 has got full support for SQL stored
    > procs (I know that atleast 7.x
    > doesn't support SQL stored procs). A number of stored procs have got
    > references to objects in MSDB database
    > of SQL server.
    > What do you think are the possible issues that we could run into during
    the
    > migration ?
    > Is UDB/Linux as robust as MS Sql server ?
    > Thanks in advace
    > - Murty
    >
    DB2 does support SQL stored procedures. But lets be clear about one
    thing--some databases go beyond SQL standards with proprietary extensions
    not supported (or supported with different coding techniques) by other
    databases. With 1200 stored procs, this is bound to be a problem for at
    least some of them, as well as with regular SQL statements.

    Make sure you only install on an IBM supported Linux release, which would
    exclude RH9. RH8 is OK.


    Mark A Guest

  2. #2

    Default Re: migration from MS Sqlserver 2000 to Linux/UDB 8.1

    Murty,

    Check out the free migration toolkit (MTK). It supports SS7 and SS2000.
    When you run the toolkit it will flag everything it thinsk will cause grief.
    You can find the MTK of the DB2 homepage or of DB2 Developer domain.

    Cheers
    Serge


    Serge Rielau Guest

Similar Threads

  1. MS SQL 2000 Data Migration w/ ColdFusion
    By ajsolimine in forum Coldfusion Server Administration
    Replies: 3
    Last Post: December 14th, 06:18 PM
  2. Coldfusino MX migration from windows to Linux
    By xinfg2133 in forum Coldfusion Server Administration
    Replies: 1
    Last Post: August 3rd, 07:45 PM
  3. Replies: 4
    Last Post: September 16th, 08:00 PM
  4. Problems with a linked server in SQLServer 2000
    By Kim Bundgaard in forum IBM DB2
    Replies: 0
    Last Post: July 17th, 10:12 AM
  5. Replies: 0
    Last Post: January 8th, 11:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139