All of the upgrade and migration tools are at the link I sent you. If the database doesn't use any esoteric functions - if it is just basic sql - you should be able to export it from 2008 as sql and execute the sql file 2005 to create a database there. If you have functionality running in 2008 that is not supported in 2005 that won't work and you'll have to exclude those functions in your export/import and find another way to do them 2005 - which can be problematic.
If you have any more questions, you can hit me offlist. Data conversions are the main part of my business and there are very few combos I haven't fought with at some point. On Fri, Sep 14, 2012 at 2:43 AM, Mike Kear <[email protected]> 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:352609 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
