by Rob Naidic » Thu, 16 Aug 2001 02:43:29
Thanks.
Rob
by Keith Kratochvi » Thu, 16 Aug 2001 03:21:56
If I remember correctly, you should be able to use the upgrade utility that
is built in to SQL2000 and do a two machine upgrade of your database from
6.5 (on the 6.5 box) to 2000 (on the 2000 box). This will leave your SQL
6.5 database untouched while creating the database on your 2k box.
--
Keith, SQL Server MVP
==============
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
Quote:> I have an old server that has a SQL 6.5 database. I would like to move a
> few of the databases on this server to a server with a SQL 2000 database.
> Is the only way to do this with the SQL Switch utility on the SQL 2000
> server? Also, if I use this utility, does it remove my old database from
> the SQL 6.5 server or does it just copy it to the SQL 2000 server?
> Thanks.
> Rob
1. moving SQL 6.5 database to another 6.5 server
Your error message may be the result of not having a trust relation between
domains. If you have a separate domain set up with your SQLServer on it,
then you need to set up trust between the two domains.
2. Execute an dts package from sql server 7.0 task
3. Using dump to move SQL 6.5 Database to SQL 7.0
4. JDeveloper - still not communicatign with SQL Server
5. Moving all databases from one SQL 6.5 server to another SQL 6.5 s erver
6. Paradox or Interbase??? (or other???)
7. HELP-Need to move SQL 6.5 database to new partition on Server!
8. Connecting to sql2000/instance1 from sql7.0 client on winNT.
9. Moving 6.5 database to another 6.5 database with different character set
10. Moving a SQL 6.5 database to SQL Server 7.0
11. Moving database from SQL 6.5 to SQL 7
12. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5
13. Moving databases and data devices to new server in SQL 6.5