Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

compatibility vs native mssql2000 to 2008 Expand / Collapse
Author
Message
Posted Wednesday, July 30, 2014 3:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 6:36 PM
Points: 2, Visits: 8
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.
Post #1597995
Posted Wednesday, July 30, 2014 3:26 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:55 PM
Points: 3,761, Visits: 8,439
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.
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?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1598007
Posted Wednesday, July 30, 2014 10:28 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 11:18 PM
Points: 1,248, Visits: 1,735
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.
Post #1598084
Posted Thursday, July 31, 2014 8:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 6:36 PM
Points: 2, Visits: 8
thanks for your tips.
Now I need to see this options.
Regards!
Post #1598289
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse