Hello, I have a website in ASP with MSSQL, which I want to move to another server. I have moved the files but I dont know how to move the database. Can anyone help. Thanks.
Are you able to back up your previous Database? If Yes, you can backup and restore it in the new server you took.
Most hosting control panels provide options to backup the databases. Optionally you can contact the support and request a backup file sent to you.
I have got the backup, uploaded it to the new database, and changed the database configuration in the web.config file. Is that all I have to do ?