compatibility vs native mssql2000 to 2008

  • Hello.

    Actually we have an Enterprise based applications with MS-SQL2000 , we have microsoft Dinamycs (6.5) and several applications (vb.net 2005, 2010 y 2012), .

    But now we plan to migrate to new serveR with MS-SQL2008.

    oUR provider says that it go to migrate our database Ms-sql2000 in the new server in compatibility mode...

    Ms-sql2008 but our database in compatibility 2000....

    It's necesary?.

    I think than may be as have a Ferrary in first march!!!!....

    what's your advice?.

    Please help me.

    thanks.

  • mjuarezh36 (7/30/2014)


    Hello.

    Actually we have an Enterprise based applications with MS-SQL2000 , we have microsoft Dinamycs (6.5) and several applications (vb.net 2005, 2010 y 2012), .

    But now we plan to migrate to new serveR with MS-SQL2008.

    oUR provider says that it go to migrate our database Ms-sql2000 in the new server in compatibility mode...

    Ms-sql2008 but our database in compatibility 2000....

    It's necesary?.

    I think than may be as have a Ferrary in first march!!!!....

    what's your advice?.

    Please help me.

    thanks.

    It really sounds like a Ferrari in first march, especially because SQL 2014 has already been released and you might want to start planning a second migration soon.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Ferraris in March, quite the bother.

    But on an unrelated note, you will need SQL 2000 compatability mode for anything as old as Dynamics 6.5. According to this, https://community.dynamics.com/sl/f/35/t/92631.aspx Dynamics 6.5 wont even work on SQL2008, and according to this https://community.dynamics.com/sl/f/35/t/49015.aspx it ended product support on April 12, 2011. You'll need to upgrade to a newer supported version of Dynamics before you can move to SQL2008.

  • thanks for your tips.

    Now I need to see this options.

    Regards!

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

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