Novick Software SQL Server Consulting Design Programming Training  

  sql server mvp

 

 

SQL Server Upgrade Consulting

Upgrading to SQL Server 2005 or 2008

SQL Server 2000 may work just great but there comes a time when upgrading to a new version becomes necessary.  It may be because  of the need for assured support and security fixes or for access to a new feature, or for better performance.  What ever the reason you may want some help preparing and executing a SQL Server upgrade.

Each upgrade starts with a review of the current configuration, code, and any existing plans.  It's important to evaluate:

  • Application connection options

  • Which version to upgrade to?  32-bit  64-bit

  • What new features will be used immediately

  • Is an edition change possible or even required?

It's important to take a look at the SQL Server objects such as tables, views, stored procs, and functions.  Will the migrate cleanly?  Is recoding necessary because they use deprecated features?  For example, this query using the old join syntax:

select OrderHeader.OrderDate, OrderHeader.OrderID
               
, SUM (Quantity * Price)
from
OrderHeader ,OrderDetail
where OrderHeader.OrderID =* OrderDetail.OrderID
group by OrderHeader.OrderID

Gives this error message:

Msg 4147, Level 15, State 1, Line 6

The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80, using the SET COMPATIBILITY_LEVEL option of ALTER DATABASE. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes.

Either this code has to be changed or the database must be run in a backwards compatibility mode, possibly limiting the use of new features.

The evaluation is followed by a plan and then an implementation.  These have to be created to fit into your operational requirements and budget. 

If you're looking for this type of help, please call Andrew Novick at 978-440-8126 or email anovick @ novicksoftware.com

Look here for information on other Novick Software projects.

 

Technologies:

SQL Server 2000
SQL Server 2005
SQL Server 2008
Reporting Services
SSIS
Data Layer
Encryption
C#
VB 6
VB.Net
ASP.Net
Compact Framework
Web Services
ASP
XML
XML DOM
XMLHTTP
SQL XML
HTTP
TCP/IP
HTML
Project Management
SourceSafe
IIS
IIS Admin
URLSCAN
T-SQL
ADO
ADO.Net
InterDev
Web Design
n-Tier
Fat Client
Database Administration
SQL Server 7
.Net
.Net Framework
.Net Security
dot Net
Encryption
Remoting
Structured Design
Structured Analysis
Entity-Relationship Diagrams
Data-Dictionary
State Diagrams
Object Design
UML Modeling
Use-Case Analysis

Locations:

Boston, MA
Nashua, NH
Cambridge, MA
Lexington, MA
Salem, MA
Gloucester, MA
Beverly, MA
Peabody, MA
Burlington, MA
Concord, MA
Belmont, MA
Arlington, MA
Woburn, MA
Reading, MA
Wakefield, MA
Lynn, MA
Somerville, MA
Charlestown, MA
Medford, MA
Watertown, MA
Nashua, NH
Manchester, NH
Boston
New Hampshire
Natick, MA
Framingham, MA
Wayland, MA
Maynard, MA
Acton, MA
Bedford, MA
Waltham, MA
Newton, MA
Needham, MA
Wellesley, MA
Weston, MA
Lincoln, MA
Marlborough, MA
Stow, MA
Berlin, MA
Bolton, MA
Littleton, MA
Chelmsford, MA
Hopkinton, MA
Ashland, MA
Franklin, MA
Worcester, MA

 

 

 

   


RSS as HTML

information about novick software site

Personal Blog

Photos

New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage

Upcoming
Presentations:

SQL PASS
Nov 7, '12
Biggest
Loser: DB
Edition


Full Schedule

 

 

Available Now

Transact-SQL
User-Defined Functions

Get it wtih the Bonus 100 UDF Library

Latest News

Novick Software Celebrates 10 Years in Business