I don't know, but you may be able to DTS the DBs back to the older version - while losing any 2008-specific features?
I know I can connect to and manage a SQL 2000 database server from 2008 enterprise manager. On 9/14/12 2:43 AM, Mike Kear wrote: > 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:352610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
