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
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
Based on previous versions i would expect perfect compatibility.
We have been able to move databases from sql 2000/2005 to 2008 without any
issues.
If you are concerned then simply install 2012 and try migrating a few
databases.
Regards
Russ Michaels
On Sep 14, 2012 3:35 AM, Mike Kear
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
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
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
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
OK, thanks everybody.I think I am fairly sure I'm going to be able to
load up anything I might develop in the future onto that client's 2005
server.
And thanks Maureen for your offer. If you dont mind, I'll keep your offer
on my desk in case I really get stuck.
Interesting, that I had
why not just run a small VM with SQL 2005 for when you need it ?
or upgrade those 2005 users to 2008/2012
On Fri, Sep 14, 2012 at 11:21 AM, Mike Kear afpwebwo...@gmail.com wrote:
OK, thanks everybody.I think I am fairly sure I'm going to be able to
load up anything I might develop in the
I don't think you will have any issues, but if your really worried about
creating 2005 databases in 2012 that aren't compatible, why don't you just
create a blank database in a 2005, then either take it offline and make a
master copy or make a backup of it. You could then use that backup to
Mike,
I think that each database has a setting for compatibility level (go
to the Properties dialog for the database, then the Options tab, it's
at the very top). As long as you leave this at SQL Server 2005 (90),
you should be able to run the same database on 2012. I don't have SQL
Server
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
12 matches
Mail list logo