Thanks, Maureeen and Russ. I fully expected to be able to upgrade 2005 databases to 2008 or further. What I'm really worried about is whether I'll be able to develop databases on my laptops with the newer database, and deploy the resulting work onto the client's SQL2005 database somehow.
Is there a converter utility or something or can i create a 2005 database using SQL Server 2008? Maybe I'd be better to install only the SQL2005 on my laptops. Cheers Mike Kear AFP Webworks Windsor, NSW, Australia. On Fri, Sep 14, 2012 at 6:38 PM, Maureen <[email protected]> wrote: > > 2005 databases will likely run without problem once upgraded to 2012 - but > you won't be able to take those databases back to a 2005 server and run > them once you've upgraded them. The issues are here: > http://msdn.microsoft.com/en-us/library/ms144256.aspx - especially the > link at the bottom for backward compatibility issues. > > You can also run multiple instances of the database - different versions - > on the same machine. That might be your best choice. > > > On Thu, Sep 13, 2012 at 7:35 PM, Mike Kear <[email protected]> wrote: > > > > > Sorry for asking an OT question, but I've been asking around Microsoft > (at > > least 10 different people in MS Support, and in Partner services) for > > more than a week and after all this time not a single MS person will even > > attempt to answer this question .... > > > > If i install a SQL Server 2012 product, (any level - Express or up to > > Enterprise ) how compatible is it with SQL Server 2005 databases? > > > > The reason I ask is I'm building new laptops for development, based on > > Windows 7 Pro OS, and want to install up to date software if i can. > But > > my major client uses SQLServer 2005 as his production database. > Therefore > > any machine I build has to be capable of developing SQL2005 databases. > > > > Does anyone here know the answer? Or else can anyone point me towards > > someone who could tell me? > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
