Thanks Larry, and that's what I'd have expected. Most software products offer a means of upgrading existing files when there's a new version. My issue is that my main client has SQL2005 databases in production. So any work I do for him has to be on SQL205 database. And any new database has to be a SQL2005 database. Any StoredProcs have to be SQL2005. So I was really asking if there are any features of SQL2012 I'm likely to use that aren't compatible with SQL2005.
It's the downwards compatibility I'm really worried about. As it happens, Microsoft tell me it can't be done - it's taken them 14 days to muster up the courage to find someone to answer my question. In the mean time several people here have told me that it's possible and not all that difficult, by simply setting the compatibility index to 90 when I create my work on my dev machine. But thanks for your input Larry - its valuable knowledge. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Sep 21, 2012 at 12:07 AM, Larry Lyons <[email protected]> wrote: > > When i upgraded, I just ran a complete backup on the 2005 db's and then > did a restore to the 2012 db. Worked like a charm, no issues at all. > > regards, > larry > > >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? > > > >-- > >Cheers > >Mike Kear > >Windsor, NSW, Australia > >Adobe Certified Advanced ColdFusion Developer > >AFP Webworks > >http://afpwebworks.com > >ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:352677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
