Post reply

Using SQL2008 with software/databases written for SQL2000?

  • May 18, 2010 at 7:40 am

    #224786

    Hi All,

    I have a situation which I am trying to resolve.

    I have some software (Omegatron's Odin Professional) which uses the free version of SQL2000. I've got the databases created and filled with data from before I upgraded to Win7.

    What I'd like to happen is to get Odin Professional back up and running, but sadly, I don't think there'll be any updates to the software anytime soon. To do this, I need to install a version of SQL that can read the databases I have, and that Odin professional can interact with.

    There were scripts provided that created the databases and made entries into the master database etc. I am not sure if these will be compatible with newer versions of SQL.

    My setup was installing SQL on the same PC as Odin Professional, so there was no server/client setup over a network etc.

    I have a TechNet subscription, so have access to the various versions of SQL available there. The old setup of SQL run 'out of the box' which made it easy to use.

    What is the best way - if there is a way - to get Odin Professional up and running again?

    Any help is much appreciated.

  • May 18, 2010 at 7:58 am

    #1168827

    I would suggest as your first step you download the SQL 2008 Upgrade Advisor from:

    http://www.microsoft.com/downloads/details.aspx?familyid=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en

    Now the tool is not the "be all" advisor, but it will get you started on your chore.

    Also view and understand the effect of compatability levels. This link might assist:

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

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • May 18, 2010 at 8:18 am

    #1168842

    bitbucket-25253 (5/18/2010)

    I would suggest as your first step you download the SQL 2008 Upgrade Advisor from:

    http://www.microsoft.com/downloads/details.aspx?familyid=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en

    From reading that page, it seems to suggest that you need to have an installation of SQL on the PC.

    In my case, there isn't such an installation, as SQL2000 is not compatible with Win7.

    Or am I reading the page wrong?

  • May 18, 2010 at 3:27 pm

    #1169133

    I think your best bet would be to contact Omegatron about this. Even if the database connection string is configurable, I would guess that the data access components compiled in their application will not allow you to connect to a SQL 2008 instance. It's been years since I've done anything with Windows apps, so that's just a guess. If that's true, upgrading your SQL version won't do you any good as far as this app goes.

    └> bt


    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • May 18, 2010 at 5:30 pm

    #1169171

    bteraberry (5/18/2010)

    I think your best bet would be to contact Omegatron about this.

    I've been trying, but either they don't have a solution to the problem and are ignoring the e-mails, or they are not around to read the e-mails.

    Although it'd be a massive pain, I suppose I could run the software in a virtual machine. It'd be slower, but at least it would work.

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

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