1 Replies - 409 Views - Last Post: 02 February 2017 - 12:10 PM

#1 depricated  Icon User is offline

  • Nero


Reputation: 2287
  • View blog
  • Posts: 5,926
  • Joined: 13-September 08

Upgrading from SQL 2000 to 2014 without using 2008 as an intermediary

Posted 02 February 2017 - 11:13 AM

I've spent a lot of time reading up on how I need to go about upgrading our prod DB from SQL 2000 to 2014.

Everything I read suggests that I load the DB in an instance of 2008, perform an upgrade from 2000 to 2008, and then repeat that from 2008 to 2014.

The problem here is that I don't have a license for 2008, and the cost is prohibitive for a one-time conversion. Like buying a new car just to get you to your old one and then abandoning it. But I don't see any alternatives, really.

So I was thinking this over, and what occurred to me is that I should be able to script out the database and then import the data. Before I started on that process though, I wanted to drop by here and see if anyone has any suggestions. I'm not really a DBA, but I am the only programmer here so that makes this my job - and one I can do, but I have far less knowledge than someone whose primary role is as a DBA. Is there another way I might be missing, or a tool you might suggest for the job?

Is This A Good Question/Topic? 0
  • +

Replies To: Upgrading from SQL 2000 to 2014 without using 2008 as an intermediary

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13392
  • View blog
  • Posts: 53,445
  • Joined: 12-June 08

Re: Upgrading from SQL 2000 to 2014 without using 2008 as an intermediary

Posted 02 February 2017 - 12:10 PM

Seems reasonable enough.. as long as the 'create table' statements line up, don't have any old legacy data types, sure.. the data export to CSV then import into the new should go well. Shouldn't take more than fifteen to thirty minutes to test table creation and then insert on a small sample size.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1