Re: Server 6.5 Upgrade

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Mon, 20 Nov 2006 12:49:06 -0500, Jay B <jayB@xxxxxxxxxxx> wrote:

i would simply detach the sql database from the 6.5 server, then copy
the 2 sql database files from the old server to the new server,
then attach them on the new server,
and its done. no conversion should be nec. it should open in
compatibility mode. then change the mode to sql2000 if you want.

It is not possible to go from 6.5 to 2000 that way. From the SQL
Server 2000 BOL documentation:

"Can you restore or attach a SQL Server 6.5 database to SQL Server
2000? Answer: No. The only way to move a SQL Server 6.5 database to
SQL Server 2000 is to run the SQL Server Upgrade Wizard."

Of course it is possible to upgrade without using any wizard if you
have 6.5 running. Script everything on the 6.5 side, run the scripts
to create the objects on the 7.0 side, then move the data using DTS,
BCP, or some other method. But that is a project, not a transaction.

Roy Harvey
Beacon Falls, CT
.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)