sql migration

You will have to install the SQL server onto the HP - you cannot simply copy it as there are numerous items to update in registry etc.

If you have Databases you want to move across, then the best way is to back them up onto a media (possibly a slave hard drive or netwrok location) that can be moved from the source machine to the target machine, and then restore the db on the target machine.

Hi,
On HP LH3000 install SQL 7.0 & from Compaq SQL backup the Databases into HP. Moreover you could backup the DBases into .dmp files & retore them to HP-SQL.
Akash

First Install SQL 7 on your new Server...
Make sure that all permissions and all settings on the new SQL Server are OK..also make sure that the ServiceSQL (what ever you named this account) is set to run as a service...Backup databases....the best if you have Backup tapes...and then restore these databases to the new Installed SQL Server...
Check again the security and the rights (permissions) for these databases after restoring them...

Good Luck

The main problems would be:
1.- Keep the same sql configuration
2.- IP address. How your clients connects?
3.- Machine name

a.- Install sql 7 into new hardware, assgin a new ip address, and a new server name.
b.- Be sure to use the same configuration schema for the new server
c.- Backup your database and move the .dat file to the new server.
d.- Restore databases to new server.
e.- Check users, permissions, and hole sql functionality.
f.- Stop and power off the old sql server.
g.- Change ip address to match the old server ip address. This will save time in configuring client odbc (unless you have dns fully working)
h.- If necesary repeat steps c and d to update data only.

Why not image the system from one computer to the other using Ghost? The only situation that will not work is if you are using a NT driven stripe set on either computer. I have used Ghost to transfer a NT 4.0 server from an IDE drive to a HP LH3 with a 3 drive RAID5 on HP?s NetRAID Controller. It can be done? Saves a ton of time and is extremely safe as you have the complete working Old Computer to fall back on. It?s a thought and a suggestion.

Ray