Re: SQL 6.5 to 2000 Upgrade Troubles
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 29 Nov 2005 10:24:32 +0000 (UTC)
=?Utf-8?B?Sm9obg==?= (John@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> I have poured through all sorts of documentation and at this point I
> would just script out the databases and run them on a 2000 installation,
> then do the data transfer, but I am not the DBA and he is "too busy" to
> be bothered with such a trivial matter (aside from the fact that I am
> not certain that he would be pf any use anyway in this matter).
>
> The short of it is this: what's the easiest way to upgrade 6.5 to 2000
> on a two machine setup? (hopefully, aside from wizards)
The easiest way in my opinion is to script everything and bulkload out
and in. That's what the wizard does anyway.
One thing to keep in mind when you extract the data, is that the native
data type may be the best - as long as you have no columns of the type
sysname, as the definition for sysname changed from 6.5 to SQL 7.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: tempdb can not delete it
- Next by Date: Re: SQL Server 2005
- Previous by thread: Dtcsetup.exe MSDTC Admin Console Problem
- Next by thread: Connecting to Reporting Services Server Fails
- Index(es):
Relevant Pages
|
