Post reply

Migrating Mode 80 to Mode 90

  • June 17, 2009 at 10:30 am

    #133010

    Hi All:

    I'm new to the neighborhood, but I'm pretty sure I'm posting in the right topic. If not, I apologize in advance.

    Our organization is performing a major upgrade of our system in 2010. Currently, we run our system on a SQL Server 2005 DBMS running Mode 80.

    As part of our major upgrade, we're looking to migrate our Database to Mode 90.

    Are there any "gotchas" or places to look that may cause problems in our custom code. I've done some research and for the most part, it seems that our code should work without changes.

    Any insight would be greatly appreciated.

    Thanks!

    Alan

  • June 17, 2009 at 10:36 am

    #1011125

    Try this:

    http://msdn.microsoft.com/en-us/library/bb510680.aspx

  • June 17, 2009 at 10:39 am

    #1011129

    First, thanks. This is exactly what I'm looking for.

    I'm sure you won't believe me when I say that I scoured MSDN for something and came no where close to finding this.

    I will now bury my head in shame and read over this document.

    Seriously, thanks a lot Johnny!

    Alan

  • June 17, 2009 at 10:41 am

    #1011132

    We did this some time back. It went very well. There was only one query that broke, and it was obvious. I don't remember the details, something about the ORDER BY clause syntax that was coded funky to begin with. And there were a lot of procs, functions etc. but it was just that one.

  • June 17, 2009 at 10:56 am

    #1011144

    I'm always glad to hear success stories. Glad to hear it wasn't too painful.

    Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply