Transfer SQL database to another ISP

[vascorp]

Hi there....

Does anyone know what is involved with transferring a SQL database from one ISP to another? Is it just a matter of redefining the name/IP of the database or does a large portion of the database need to be reprogrammed.

We had a contractor create our database driven website and have to switch ISPs. Just trying to verify the information he gave us.

Thanks

 

[Sammy145]

obviusly u need the database on the new server

but yes IP/name is all you change if you refrence by IP or name
you will need to setup SAME SQL LOGIN AND PASSWORD if you dont know it

OR is your connection using DSN