Please follow the steps below to restore your SQL Express database to our MSSQL 2012 server. There are 2 methods, one is Attach and one is Restore. Please read below:
Attach your .MDF file:
You can use the attach function to attach your sql express database to our mssql 2012 server, please follow the instructions below
1. Login to your hosting control panel --> Database Manager-->SQL Server Manager to create a new database
2. Use FTP to upload your current .mdf file to your hosting account. ( You normally can find your .MDF in your App_Data folder).
3.
go to your hosting control panel --> Database Manager-->SQL
Server Manager, click "Attach" beside the new database you just
created, use your .mdf file to attach it.
4.
Click 'View Info' beside the new database, you can find the new
database's server name, database name , database Login id , database
password.
5. Open your web.config file to change your database connection string with your new database info.
Change
<add name="ConnectionString" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\datafilename.MDF;Integrated
Security=True;User Instance=True;Initial Catalog=dbname" providerName="System.Data.SqlClient"/>
To
<add name="ConnectionString" connectionString="Server=SQLServerAddress,1433;Initial Catalog=DBName;uid=DBLogin;pwd=DBPassword;" providerName="System.Data.SqlClient" />
Note, please replace 'SQLServerAddress', 'DBName',
'DBLogin', 'DBPassword' with the exact value of your database in your account. Please make sure you do not change port 1433 to 2433.
Backup and Restore your .BAK file:
You can use restore function to restore your sql express database to our mssql 2012 server, please follow the instructions blow
1. Login to your hosting control panel --> Database Manager-->SQL Server Manager to create a new database
2. Use FTP to upload your current SQL Express database backup file (.bak file) to DB folder.
3. go to your hosting control panel --> Database Manager-->SQL Server Manager, click "Restore" beside the new database you just created, use your SQL Express database backup file to restore it.
4. Click 'View Info' beside the new database, you can find the new database's server name, database name , database Login id , database password.
5. Open your web.config file to change your database connection string with your new database info.
Change
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\datafilename.MDF;Integrated Security=True;User Instance=True;Initial Catalog=dbname" providerName="System.Data.SqlClient"/>
To
<add name="ConnectionString" connectionString="Server=SQLServerAddress,1433;Initial Catalog=DBName;uid=DBLogin;pwd=DBPassword;" providerName="System.Data.SqlClient" />
Note, please replace 'SQLServerAddress', 'DBName',
'DBLogin', 'DBPassword' with the exact value of your database in your account. Please make sure you do not change port 1433 to 2433.