Re: OLD SQL-Server Upgrade 7 to SQL 2000

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 09:17:46 -0400

Unless you have an application that requires a different collation, just use
the default. Obviously, you will need to test your restore and cutover
strategy a lot before the final switch. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Wallman" <Wallman@discussions.microsoft.com> wrote in message
news:6D4ED8D3-A6A7-4909-9C8F-504183162365@microsoft.com...
> Hi everybody, for a couple of years ago we made the upgrade from 7 to 2000
> and now we want to move the server to a Windows 2k3, the problem is how we
> should set up the new SQL-server.
> I dont know wish sortorder to use, when we upgraded the sql 7 box to sql
2k
> we got this sortorder Compatibility_42_40b_30001, what is that?
> I tried with multiple sortorders but it seems that this one dosnt exist, I
> even searched the microsoft site for some info but couldnt find anything
> around this.
> Please anybody help me with this one, I cant use transfer due to the
> compexity of the db structure, so I realy need to use the Backup from the
old
> box.

Relevant Pages

  • RE: SP3a not installing
    ... Upgrade an instance of Microsoft SQL Server 2000 Desktop Engine to ...
    (microsoft.public.sqlserver.server)
  • RE: Sharepoint issue
    ... do you mean Microsoft SQL Server ... 833183 You receive a "Cannot connect to the configuration database" error ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Connecting remotely through VPN
    ... Reason: Your upgrade is blocked. ... Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books ... information about edition upgrades, see the Version and Edition Upgrades ... I think that your SQL Browser Service did not work well. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL 2005 wont upgrade using R2 discs
    ... But when I try and upgrade the default instance I still get this error: ... Microsoft SQL Server 2005 Tools ... I uninstalled the SQL 2000 version and it let me install ... information about edition upgrades, ...
    (microsoft.public.windows.server.sbs)
  • Re: Creating a new Access database file (.mdb) in .NET/C#
    ... You definitely need to download my Ebook. ... It can be passed around as a file like JET and backed up in a similar fashion. ... Consider that this database is also fully encryptable--a feature not in JET or in SQL Server until 2008. ... Per the MS product pages, I'm eligible for the Upgrade package, and ...
    (microsoft.public.dotnet.framework.adonet)