|
Support Chat
For migration issues,
please use Live chat.
|
Microsoft SQL 2000 Database Migration Issues
- Microsoft SQL 2000 database connection string – If
your site or account is using a Microsoft SQL 2000 database then you will
need to update the IP address and port number of your SQL connection string
on your pages or programs that dictate where to connect to the database.
Refer to the new server IP chart at
http://www.1planhost.com/migration/iplist.asp for a list of the old and new SQL server
IP addresses and port numbers. For example, if your connection string
currently refers to 216.153.93.6:1065 then for the new server you will need
to change it to 216.74.123.6:1065
- Old data on MS SQL 2000 database is showing up on new server -
First, ensure that you have changed the connection string and the database
results you are viewing are indeed the new SQL 2000 server. If it is, then
it is most likely due to our restoring your SQL database from an older
backup date of March 16, 2006. To correct this, open the older SQL 2000
database using Enterprise Manager and then use DTS (Data Transformation
Service) to sync up your older db with the new db on the new server. The
login information (user/pass) should be the same for both the old and new
databases. If you have difficulties with the DTS process, please create a
support ticket at
https://www.1planhost.com/esupport and request that we backup your old
SQL 2000 db and restore it on the new SQL 2000 db server. Important: Please
include ALL of your db information in the ticket such as the database name,
old and new IP address and port number, username and password.
|
