addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobe--smallglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1launch-new-window--smalllight-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

RE: [PhillyDB] upgrading sql server 2000 database to sql server 2012

From: Patricia P.
Sent on: Monday, April 9, 2012 5:22 PM

A good place to start is to run the upgrade advisor which is a free download at  Running this will tell you about any problems you may have in upgrading.  This is the upgrade advisor for SQL 2008.  There’s probably one  for SQL 2012.  (I haven’t touched SQL 2012 yet).  You may already be aware that you can run a SQL 2000 database on SQL 2008 in “SQL 2000 mode” (which means you can’t use some SQL 2008 features but you can run it unchanged) but you can’t run SQL 2000 on SQL 2012.  You can run a SQL 2008 database (again, with restricted functionality but totally unchanged) on SQL 2012.

You’re right about the difficulty in estimating without seeing the specific database.  I’ve upgraded 3 different databases from SQL 2000 to SQL 2008, averaging maybe about 40 hours each.  The first one I was lucky to get all the errors in a week whereas the other two, I got the warnings out as well.


BTW, I worked on a database for the Mural Arts program.  I can’t remember what year (but around 2004) and whether it was SQL Server or Access but I was helping out a friend who was working there.   I remember being impressed with the art work by prisoners on the walls.


From: [address removed] [mailto:[address removed]] On Behalf Of Maneesha
Sent: Monday, April 09,[masked]:47 PM
To: [address removed]
Subject: [PhillyDB] upgrading sql server 2000 database to sql server 2012


Seeking some advice about an oudated database system we're working with.


I work with the City of Philadelphia's Mural Arts Program.  In 2004, we contracted with a local database developer to develop a system that allows us to track student participation in our after school art programs.  It tracks each student's address, demographics, what classes they enroll in, daily attendance, paperwork/documentation, class progress,  etc.   It was built on SQL Server 2000.


Because of issues with the city's technology systems back then we were not able to install it right away.  When they finally got around to supporting us (I think around 2006 or 07), they gave us SQL Server 2005.  We ended up installing an instance of SQL Server 2000 on SQL Server 2005 which itself runs on Windows Server 2003.  


As of a few years ago, we are no longer under the city's technology systems and manage our own systems through independent contracted consultants.  Last year, we terminated our contract with the original database developer because he wasn't following through on a number of issues we needed addressed over the years.  Last year, we also went through a major overhaul of all our servers and desktops.  


We've upgraded all  our other servers but we still have one server left that's still running SQL server 2000 and Windows 2003 just  because of this one outdated db system.  We'd like to upgrade both SQL Server to 2012 and Windows Server  to 2008R2 on this last server. 


I'm trying to budget for how many hours it would take to upgrade a SQL Server 2000 database so it will run on SQL Server 2012. I realize you can't really tell much without actually seeing what we're working with, but all I'm looking for now is a ballpark figure (i.e., is it in the 20-30 hour range? 50 hours? 100 hours?).


If there is any other info I can provide to help get at an estimate feel free to email me back.


Thanks for any help!



Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Maneesha ([address removed]) from PhillyDB.
To learn more about Maneesha, visit his/her member profile
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy