Install install your prefered visual studio like visual studio 2005, SQL server 2005 express & Microsoft SQL SERVER DATABASE PUBLISHING WIZARD.
Purchase domain name & webspace from hosting service provider like GoDaddy, bluehost, hostinger,....
Create a web application on your prefered location like d:\httpdocs folder with database like websoft.mdf
Create .SQL script of your database;
From Server Explorer -> right click on database like websoft.mdf -> choose Publish to Provider -> it shows database publishing wizard -> Click next -> select your database like d:\httpdocs\App_Data\websoft.mdf -> click next -> it shows select an output location -> set location where.sql file you want to create like c:\Users\websoftbuilder\Documents\websoft.mdf.sql -> click next -> it shows select publishing option leave default settings as;
Drop existing objects in script=true, Schema quality=true, script for target database=SQL SERVER 2005, Type of data to publish=Schema and Data -> click next -> click on finish -> wait till database publishing process success -> click on close.
Open the script file from where you created like c:\Users\websoftbuilder\Documents\websoft.mdf.sql it open with Microsoft SQL SERVER management studio express. -> click on cancel -> it shows Websoft.mdf.sql file contents -> copy this all contents.
Open your website hosting service purchased control panel using your given login details like as;
Control panel login URL: https://sailanddeveloper.in:8443
Control panel User name: sailanddeveloper.in
Control panel Password: host123
It shows Security issue window -> click on Approve -> it will open the Log in to Parallels plesk panel 9.5 login to this with your login details like;
Login: sailanddeveloper.in
Password: host123
Interface Language: Default
Click on Login button -> it shows logged in as sailanddeveloper.in -> click on database -> it shows all databases in this domain -> click on Add New Database -> it shows options as follows;
Database name*= here you type websoft
Type=Microsoft SQL server
Click on ok button -> it shows message like information: The database websoft has been created.
Click on Up Level -> again it shows all databases present in the domain.
Click on websoft database shown in the list -> it shows Users for database websoft on domain sailanddeveloper.in
Click on Add New Database User -> it shows Ads Database User in database websoft -> type following things or your preferred things;
Database user name*=BHAGAWAN
New password=NARSHIKAR
Confirm password=NARSHIKAR
click on ok button -> it returns to Users for database websoft on domain sailanddeveloper.in -> Return to Databases for domain sailanddeveloper.in it shows;
Click on Database management via web interface shown right side of the database -> it shows Security warning -> click on submit button -> it shows mylittleadmin as follows;
Click on user database shown on left side -> it shows websoft database in the userdatabase option -> click on websoft -> it shows all contents on the database like Tables, Views, ....etc.
Click on tables for creating tables click on Tools option it shows New Query option select this -> it shows New Query window like follows;
Select Database as websoft on the drop-down list shown -> here you can pate the .SQL files content -> click on submit button -> wait till the message shown changed database context to 'websoft' -> click on submit button -> To see the table created click on Database option -> click on user database -> click on websoft -> click on tables -> it shows table & their columns created -> close Mylittleadmin -> Logout from Parallels Plesk panel.
Lastely go to the Visual studio & make some changes in the web.config file from your application.
Following is the web.config file;
<?XML version="1.0"?>
<configuration>
<appSettings/>
<connectionStrings>
<clear/>
<add name="websoftbuilder" connectionString="Server=mssql.sailanddeveloper.in; Database=websoft; UserID=BHAGAWAN; Password=NARSHIKAR;" providerName="System.Data.SqlClient"/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="DataSource=.\SQLExpress; Integrated Security=True; User Instence=True; AttachDBFilename=.\App_Data\websoft.mdf"/>
</connectionStrings>
<system.web>
<compilation debug="false"/>
<authorization mode="windows"/>
<customErrors mode="Off"/>
</system.web>
</configuration>
Finally Upload all folders, files used in your web application through FTP upload software or through Parallels plesk panel.
RUN THE WEBSITE IT WORKS FINE.
If you required see our new blogs coming on;
1) How to Upload all folders, files used in your web application through FTP upload software or through Parallels plesk panel.
2) If existing table contents not showing after website online runing what to do!
3) If you using auto generated columns in your application & added testing data if you want to delete all contents from that table you must use Truncate SQL command it delete table data & auto generated columns value sets to zero. If you deleted table data using delete command it delete table data but auto generated columns value not set to zero.
4) How to set default error page.
No comments:
Post a Comment