As a request form one of my follower I am writing this post about how to upload your Ms. SQL Server Database. Just follow my steps and in new few minutes your database will be on line in your Godaddy server.
Step 1:
First generate a script of your database with data (Schema & data).
Step 2:
Open your Godaddy server login into it and Go to Web Sites and Domain section. There is a link for Database (marked in pic) section. Click on it and you will be redirect to Database section.
Step 3:
Right now there is no database exists. So you have to create a new one. Click on the Add new database button and go to Add New Database page.
Step 4:
Here you have to enter your database name and choose Microsoft SQL Server from Type drop down list.
Now its come to the user part. Here I don't have an exiting user so I have to create an user to access the database. So enter the user name and password for the user. You can generate the password for user also.
After all entry click on the OK button and if there is no issue you will be redirect to the previous page where you can see that you have a database with your given name and its user. Now your database is created and you can add your tables, stored procedures, functions, views and also insert data.
Note: make a note of the provided IP address and pin no. It will use in case of writing connection string in your web.config file.
Step 5:
To modify your database click on the webadmin link on the right side of your database. It will redirect you to a database management tool.
Step 6:
Click on the Tools section and within that on New Query button.
Step 7:
A new editor will be open for you to write sql query in it. Now copy and paste your local database script into this editor and click on the submit button.
Step 8:
After few minutes(as per your database size) your database will be on line. Now go back to your project. You have to change the connection string of you web.config file to attach this on line database.
Add the following connection string:
Now upload your project and enjoy with your website.
Step 1:
First generate a script of your database with data (Schema & data).
Step 2:
Open your Godaddy server login into it and Go to Web Sites and Domain section. There is a link for Database (marked in pic) section. Click on it and you will be redirect to Database section.
Step 3:
Right now there is no database exists. So you have to create a new one. Click on the Add new database button and go to Add New Database page.
Step 4:
Here you have to enter your database name and choose Microsoft SQL Server from Type drop down list.
Now its come to the user part. Here I don't have an exiting user so I have to create an user to access the database. So enter the user name and password for the user. You can generate the password for user also.
After all entry click on the OK button and if there is no issue you will be redirect to the previous page where you can see that you have a database with your given name and its user. Now your database is created and you can add your tables, stored procedures, functions, views and also insert data.
Note: make a note of the provided IP address and pin no. It will use in case of writing connection string in your web.config file.
Step 5:
To modify your database click on the webadmin link on the right side of your database. It will redirect you to a database management tool.
Step 6:
Click on the Tools section and within that on New Query button.
Step 7:
A new editor will be open for you to write sql query in it. Now copy and paste your local database script into this editor and click on the submit button.
Step 8:
After few minutes(as per your database size) your database will be on line. Now go back to your project. You have to change the connection string of you web.config file to attach this on line database.
Add the following connection string:
<add name="mlm_real_1050ConnectionString" connectionString="Data Source=<IP address>,<PIN No>; Initial Catalog=<Database name>;Network Library=DBMSSOCN;User ID=<User Name>;Password=<Password>;" providerName="System.Data.SqlClient" />
Now upload your project and enjoy with your website.
sir,
ReplyDeletepl. tell me how to upload file to a folder(which is in the running server) and its address to the database which is also int he server with different ip.
helo sir .....According to your step....i do everything......bt finaly i got IIS error....i think its database connectivity problem....how can i fix it...please replay...
ReplyDelete