迁移到SQL 2003 [英] Migrating to SQL 2003

问题描述

我们正在运行SQL 7，使用Access 2000作为前端。我们的网络人员

想要迁移到Windows 2003（我们目前在Windows 2000上），并且

想知道我们是否应该迁移到SQL 2003同时。 SQL 7和SQL 2003之间是否有重大变化，以及将我们的单个数据库迁移到新版SQL的任务有多难？
/>

谢谢，


Neil

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

推荐答案

嗯，你呢？想要迁移到SQL 2000或SQL 2005？


MC


" Neil" <无**** @ nospam.net>在消息中写道

新闻：Y _ *************** @ newsread3.news.pas.earthlin k.net ...

Ummm, do you want to migrate to SQL 2000 or SQL 2005?

MC

"Neil" <no****@nospam.net> wrote in message
news:Y_***************@newsread3.news.pas.earthlin k.net...

我们正在运行SQL 7，使用Access 2000作为前端。我们的网络人员想要迁移到Windows 2003（我们目前在Windows 2000上），并想知道我们是否应该同时迁移到SQL 2003。在SQL 7和SQL 2003之间是否存在重大变化，以及将我们的单个数据库迁移到新版本的SQL会有多么困难？

谢谢，

Neil

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

Neil（no****@nospam.net）写道：

Neil (no****@nospam.net) writes:

我们使用Access 2000作为前端运行SQL 7。我们的网络人员想要迁移到Windows 2003（我们目前在Windows上2000年），并想知道我们是否应该在相同的时间迁移到SQL 2003。 SQL 7和SQL 2003之间是否有重大变化，以及将我们的单个数据库迁移到新版本的SQL的任务有多难？

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?

没有SQL 2003.现在有一个非常成熟的SQL 2000，并且

有一个月前发布的SQL 2005.


虽然SQL 2005比SQL 2000有了很大的改进，但是将数据库迁移到SQL 2005很可能是一项简单的任务，尽管它有一个很好的例子。

是一些不兼容性，特别是如果你寻求兼容性

90级（我推荐）。

-

Erland Sommarskog，SQL Server MVP ， es****@sommarskog.se


SQL Server 2005联机丛书在
http：// www .microsoft.com / technet / pro ... ads / books.mspx

Books Onl用于SQL Server 2000的ine
http：// www.microsoft.com/sql/prodinf...ons/books.mspx

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 incompatibilities, particularly if you head for compatibility
level 90 (which I recommend).
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.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

Erland。感谢您的回复。鉴于SQL

2005和SQL 97之间存在不兼容性，您认为升级到SQL 2000是否明智？

此外，任何关于哪一个可能更好的想法适用于Windows 2003

和/或ODBC环境（使用Access MDB作为前端）？谢谢！


Neil

" Erland Sommarskog" < ES **** @ sommarskog.se>在消息中写道

news：Xn ********************** @ 127.0.0.1 ...

Hi, Erland. Thanks for your reply. Given the incompatibilities 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****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...

Neil（no****@nospam.net）写道：

Neil (no****@nospam.net) writes:

我们正在运行SQL 7，使用Access 2000作为前端。我们的网络人员想要迁移到Windows 2003（我们目前在Windows上2000年），并想知道我们是否应该在相同的时间迁移到SQL 2003。 SQL 7和SQL 2003之间是否有重大变化，以及将我们的单个数据库迁移到新版本的SQL的任务有多难？

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?

虽然有很大的改进SQL 2000 over SQL 2000，将数据库迁移到SQL 2005很可能是一项简单的任务，尽管有一些不兼容性，特别是如果你追求兼容性级别90（我推荐） }。

-
Erland Sommarskog，SQL Server MVP， es****@sommarskog.se

SQL Server 2005的在线书籍
http://www.microsoft.com/technet/pro...ads/books.mspx
SQL Server 2000的联机书籍
http://www.microsoft.com/sql/prodinf...ons/books .mspx

这篇关于迁移到SQL 2003的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！