473,545 Members | 2,021 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Migrating to SQL 2003

We are running SQL 7, using Access 2000 as a front end. Our network person
is wanting to migrate to Windows 2003 (we're currently on Windows 2000), and
wants to know if we should migrate to SQL 2003 at the same time. Are there
major changes between SQL 7 and SQL 2003, and how hard of a task would it be
to migrate our single database to a new version of SQL?

Thanks,

Neil
Dec 12 '05 #1
11 2242
MC
Ummm, do you want to migrate to SQL 2000 or SQL 2005?

MC

"Neil" <no****@nospam. net> wrote in message
news:Y_******** *******@newsrea d3.news.pas.ear thlink.net...
We are running SQL 7, using Access 2000 as a front end. Our network person
is wanting to migrate to Windows 2003 (we're currently on Windows 2000),
and wants to know if we should migrate to SQL 2003 at the same time. Are
there major changes between SQL 7 and SQL 2003, and how hard of a task
would it be to migrate our single database to a new version of SQL?

Thanks,

Neil

Dec 12 '05 #2
Neil (no****@nospam. net) writes:
We are running SQL 7, using Access 2000 as a front end. Our network
person is wanting to migrate to Windows 2003 (we're currently on Windows
2000), and wants to know if we should migrate to SQL 2003 at the same
time. Are there major changes between SQL 7 and SQL 2003, and how hard
of a task would it be to migrate our single database to a new version of
SQL?


There is no SQL 2003. There is SQL 2000 which is very mature now, and
there is SQL 2005 which was released just over a month ago.

While there are vast improvements in SQL 2005 over SQL 2000, migrating
your database to SQL 2005 can very well be a simple task, although there
are some incompatibiliti es, particularly if you head for compatibility
level 90 (which I recommend).
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 12 '05 #3
Hi, Erland. Thanks for your reply. Given the incompatibiliti es between SQL
2005 and SQL 97, do you think it would be wise to just upgrade to SQL 2000?
Also, any ideas about which one might be better suited for Windows 2003
and/or an ODBC environment (using Access MDB as a front end)? Thanks!

Neil
"Erland Sommarskog" <es****@sommars kog.se> wrote in message
news:Xn******** **************@ 127.0.0.1...
Neil (no****@nospam. net) writes:
We are running SQL 7, using Access 2000 as a front end. Our network
person is wanting to migrate to Windows 2003 (we're currently on Windows
2000), and wants to know if we should migrate to SQL 2003 at the same
time. Are there major changes between SQL 7 and SQL 2003, and how hard
of a task would it be to migrate our single database to a new version of
SQL?


There is no SQL 2003. There is SQL 2000 which is very mature now, and
there is SQL 2005 which was released just over a month ago.

While there are vast improvements in SQL 2005 over SQL 2000, migrating
your database to SQL 2005 can very well be a simple task, although there
are some incompatibiliti es, particularly if you head for compatibility
level 90 (which I recommend).
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jan 26 '06 #4
Neil (no****@nospam. net) writes:
Hi, Erland. Thanks for your reply. Given the incompatibiliti es between
SQL 2005 and SQL 97, do you think it would be wise to just upgrade to
SQL 2000? Also, any ideas about which one might be better suited for
Windows 2003 and/or an ODBC environment (using Access MDB as a front
end)? Thanks!


SQL 97? Do you mean Access 97?

I can't give any advice that involves Access as this is an unknown product
to me.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 26 '06 #5
On Thu, 26 Jan 2006 05:02:36 GMT, Neil wrote:
Hi, Erland. Thanks for your reply. Given the incompatibiliti es between SQL
2005 and SQL 97, do you think it would be wise to just upgrade to SQL 2000?
Also, any ideas about which one might be better suited for Windows 2003
and/or an ODBC environment (using Access MDB as a front end)? Thanks!

Neil


Hi Neil,

If you're upgrading anyway (whether from SQL 7 or fram Access 97, I
don't know), then I'd recommend you to go for SQL 2005. Every upgrade
you ever do will require you to deal with SOME incompatibiliti es. But
from SQL 7 to SQL 2005 should be relatively easy. (From Access [any
version] to SQL Server [any version] might be more trouble).

The payoff will be bigger if you go straight for 2005 - especially when
you start using the new features. Plus you'll be settled for some time
to come!

--
Hugo Kornelis, SQL Server MVP
Jan 26 '06 #6
I meant SQL 7.

I'm mainly looking for advice re. compatibility with Windows 2003, and
possibly ODBC environments.

Thanks.
"Erland Sommarskog" <es****@sommars kog.se> wrote in message
news:Xn******** **************@ 127.0.0.1...
Neil (no****@nospam. net) writes:
Hi, Erland. Thanks for your reply. Given the incompatibiliti es between
SQL 2005 and SQL 97, do you think it would be wise to just upgrade to
SQL 2000? Also, any ideas about which one might be better suited for
Windows 2003 and/or an ODBC environment (using Access MDB as a front
end)? Thanks!


SQL 97? Do you mean Access 97?

I can't give any advice that involves Access as this is an unknown product
to me.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jan 27 '06 #7
Hi, Hugo. Thanks for the reply. See below.

"Hugo Kornelis" <hu**@perFact.R EMOVETHIS.info> wrote in message
news:1k******** *************** *********@4ax.c om...
On Thu, 26 Jan 2006 05:02:36 GMT, Neil wrote:
Hi, Erland. Thanks for your reply. Given the incompatibiliti es between SQL
2005 and SQL 97, do you think it would be wise to just upgrade to SQL
2000?
Also, any ideas about which one might be better suited for Windows 2003
and/or an ODBC environment (using Access MDB as a front end)? Thanks!

Neil
Hi Neil,

If you're upgrading anyway (whether from SQL 7 or fram Access 97, I
don't know),


It's from SQL 7. We are currently using Access with a SQL 7 back end.
then I'd recommend you to go for SQL 2005. Every upgrade
you ever do will require you to deal with SOME incompatibiliti es. But
from SQL 7 to SQL 2005 should be relatively easy.
Erland mentioned "compatibil ity level 90" as possibly entailing some
incompatibiliti es. Would you concur?

(From Access [any version] to SQL Server [any version] might be more trouble).

The payoff will be bigger if you go straight for 2005 - especially when
you start using the new features. Plus you'll be settled for some time
to come!
I certainly agree with that. The only issue would be if there were a main
difference between upgrading to 2000 vs. 2005. But if upgrading to 2000 or
2005 were more or less the same, then I'd agree that 2005 would be the way
to go.

Thanks!

Neil


--
Hugo Kornelis, SQL Server MVP

Jan 27 '06 #8
On Fri, 27 Jan 2006 08:27:25 GMT, Neil wrote:
then I'd recommend you to go for SQL 2005. Every upgrade
you ever do will require you to deal with SOME incompatibiliti es. But
from SQL 7 to SQL 2005 should be relatively easy.


Erland mentioned "compatibil ity level 90" as possibly entailing some
incompatibilit ies. Would you concur?


Hi Neil,

Compatibility level 90 means that you unlock all the new features that
were implemented in SQL Server 2005. Upgrading to SQL Server 2005
without striving for compatibility level 90 is, IMHO, a bit silly.

Lower compatibility levels are included to make upgrading easier. At
compatibility level 70, many features still behave the same as in SQL
Server 7.0. Not all, though - some changes to the core of the DB engine
were just too drastic to allow mimicking the "old" behaviour.

Upgrading from SQL Server 7.0 to SQL Server 2005 at compatibility level
70 means that you have to make only minimal changes - you don't have to
change the features that are still supported in the compatibility level.
But this should only be a first step - the next step should be to
replace old functionality with new functionality, then set the
compatbility level to 90. And after that, you can begin to unleash the
true power of all the new features!

--
Hugo Kornelis, SQL Server MVP
Jan 27 '06 #9
Neil (no****@nospam. net) writes:
Erland mentioned "compatibil ity level 90" as possibly entailing some
incompatibiliti es. Would you concur?


You can choose compatibiliy level 70. There still are cases of what
is is illegal syntax bot not caught by SQL 2000. (Don't know if SQL 7
has the same issues.) But with compatibility level 70, some functionalit
will not be available to you.

Beside mew reserved keywords, the main issue is the old-style outer
join (*= and =*) that are not permitted in level 90. If you have this,
rewrite it, because this is crap.

Note that you could run into issues if you upgrade to SQL 2000 as
well, althogh I think difference between level 70 and 80 is just
three keywords.
I've seen some mentions that Access 2003 is not co-operative with SQL2005,
but you probably get better answer on that in an Access newsgroup.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 27 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
8501
by: Bernardo Robelo | last post by:
Hi, I am interested in migrating Microsoft Access database to Postgres database. But I do not have idea of like initiating. Maybe some tool exists for this problem. Thanks you. Bernardo
6
2747
by: Shai Levi | last post by:
Hi, I'm trying to migrate native c++ class to managed c++ class. The native class header definition looks as: class NativeClass { public: typedef void (CbFunc1)(int n,void* p);
3
1202
by: Mike Doyle | last post by:
Hi, I'm looking at migrating our existing from Visual Studio (6.00) C++ code to the .NET version of C++ (unmanaged) Can anyone point me towards documention or an overview of this ? Thanks in advance, MD
6
980
by: guy | last post by:
When migrating VB2003 source code to VB2005 are there any breaking changes? I can only find info that refers to different versions of the framework, and which is not what im looking for. cheers guy
2
1493
by: Stuart Quinn | last post by:
Is there anything special I should know about migrating my website from 1.1 to 2.0? I was just planning to add new pages to a project in 2.0, and then copy the 1.1 pages over one by one. Does that sound like a good approach? Is there an easier way?
0
1174
by: chowdhp | last post by:
Hi, I am trying to migrate our server MSSQL2000 to MSSQL2005 and getting the following errors. 1. When I tried to restore the Master DB in the test server(single user mode) from a backup file it says version mismatch. I cannot detach and attach the master database as it is in the production server! 2. While migrating the DTS I got the...
9
2748
by: wandii | last post by:
Hi, I have written couple of projects which include several crystal reports in VS.net 2003 (VB.Net) and company would like to move to VS 2005. What does it take to convert to Visual Studio.Net 2005? Can the 2003 project just be opened up in 2005? Will that convert it. The interface for 2005 very different from 2003. I got the VS 2005...
0
930
sangeetha jagannathan
by: sangeetha jagannathan | last post by:
visual c++ .net 2003 is also called as visual c++ 7.1. now i am migrating my project which is built on visual c++ 6.0 to visual studio .net 2003 is there any spacific procedure to migrate it. i am finding lots of compile time error which is 1000 in number. plz do help me
2
1606
by: CKKwan | last post by:
The Web Project in VS 2003 is created in the inetpub. But in VS2005 / 2008, they store together in the project / soluction directory. Now, when I am migrating, how can I ensure that all these files (in the inetpub) are moved into the project directory. More importantly is that I do not have inetpub in my vista and is not allowed to...
0
7475
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7409
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7664
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7436
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7766
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5981
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3446
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1897
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
715
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.