Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I need to estimate a project to convert a SQL Server 2000 database with database replication to SQL Server 2008. Anyone have thoughts on how I can estimate the level of effort to perform the conversion? I'm thinking of outsourcing the task so that I have the expertise of someone that's been through this before. I would like to estimate and budget for the project, but I'm not sure of how big of a task this is really going to be.

share|improve this question

migrated from stackoverflow.com Oct 8 '10 at 18:16

This question came from our site for professional and enthusiast programmers.

closed as not a real question by sysadmin1138 Jan 9 '12 at 21:43

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Are talking about programming changes to an application that runs against the database, or just updating the database itself? –  Peter Oct 8 '10 at 18:03
1  
As-is, too vague for anyone to provide a decent answer. –  OMG Ponies Oct 8 '10 at 18:04

2 Answers 2

Running the SQL server upgrade advisor should provide a good overview of what changes will be needed.

share|improve this answer

You can go through the 490 page long SQL Server 2008 Upgrade Technical Reference Guide to get some idea of the work involved. Of course, not all 490 pages will be relevant for your case, but many chapters are of interest, like 4.7 Upgrading Replicated Databases or 8. T-SQL Queries. You don't have to read through all the paper and become an expert yourself, but you can use the paper to specify your job requirements and to judge the quality of the offers you get.

share|improve this answer
    
Thanks for the info. This will help me get started. –  Julie Oct 8 '10 at 18:13