o the new installation.
Chris
--
Original Message
From: "CF-Talk"[EMAIL PROTECTED]
Subject: Re: Moving SQL to new server
Date: Wed, 4 Oct 2000 23:34:24 +0200
In MS-SQL-Server 6.5 there was a feature called Transfer Manager.
You could have used it to transfer data,
We are in the process of installing a new web server box. Everything is going OK
except I'm getting held up on transferring the SQL databases. The current plan is to
take the file created by the backup process and move it to the new box and use the
restore wizard in Enterprise Manager. The new
We are in the process of installing a new web server box.
Everything is going OK except I'm getting held up on
transferring the SQL databases. The current plan is to take
the file created by the backup process and move it to the new
box and use the restore wizard in Enterprise Manager.
I am no sql expert, but I had the same problem, and solved it by using the
export wizard. Just highlight the database in sql server and right click -
select export... then follow the wizard and select the new sql server as
the destination. Went quickly and easily. (assuming both are
Are you going from SQL 7 to SQL 7? If so, just transfer to data using
DTS. I have done this a few times. Works fine for me.
Install SQL 7
configure and set up your users
Export from the old SQL and import it into the new SQL.
I find it better to create the database (leave it blank) on the
On Wednesday, October 4, 2000, Dave Watts [EMAIL PROTECTED] wrote:
We are in the process of installing a new web server box.
Everything is going OK except I'm getting held up on
transferring the SQL databases. The current plan is to take
the file created by the backup process and move it
That still results in the same error. I even went so far as
to create a new database, use DTS to transfer all objects and
data, create a backup with the same name, replace that back
up with the backup from the source and I still got an error
saying it's a different database. If I select
mchine.
Uwe
- Original Message -
From: "Dave Watts" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Mittwoch, 4. Oktober 2000 21:39
Subject: RE: Moving SQL to new server
That still results in the same error. I even went so far as
to create
8 matches
Mail list logo