Click here to Skip to main content
15,891,431 members
Please Sign up or sign in to vote.
2.60/5 (2 votes)
See more:
Hi
I have completed my asp.net web application project, now how do i make it live?

I have my company servers where I can upload all the files through ftp file transfer.

but doing so will be suffice?

Do i have to change the connection string anywhere or how to upload the database?

XML
<add name="InventoryDatabaseConnectionString" connectionString="Data Source=.\INSTANCE;Initial Catalog=InventoryDatabase;Integrated Security=True" />


this is the connection string written in web.config now in my system

How do i do the entire process?

Can anyone please help me?

Thanks
Sudeshna
Posted
Updated 10-Feb-15 16:14pm
v2
Comments
Kornfeld Eliyahu Peter 10-Feb-15 4:53am    
Search for 'publishing asp.net website'...
sudeshna from bangkok 10-Feb-15 4:55am    
i searched. i am getting half information. can you please just tell the procedure? It will be a great help to me

Most of of the cases I have observed that the backup of database from express versions do not work on servers because Microsoft has provided express versions of SQL servers for learners. These versions work very well on local machines their database will have different for example (.sdf) is an extension for MS SQL express version and (.mdf) is for professional MS SQL version. First of all please pay attention for this issue. Instead this thing I will suggest you to just develop new database and table straight on SQL server. Then get the connection string as per the online server you have used. Now replace the connection string.

Now this is the time to compile and publish the solution. There different ways to publish an ASP.net solution. The easiest way is:

  1. Go to build menu and click on "Publish website". It will give you a dialog box "Publish Web"
  2. Options displayed on this dialog box may differ as per the version of visual studio you are using. Some of the Trial Visual studio versions do not have even "Build" menu. In the latest profession versions like "Visual studio 2012 / 2013 pro." will ask you to create profile. On the " Profile" tab, add new profile by choosing "Custom" and click "OK".
  3. It will take you for different methods of "Publish". It is you own choice as per your circumstances if you have "ftp" link and password for your webserver then you can choose ftp. The easier methods for beginners are :
    Web deploy package and File System.
  4. Now choose "File System" and browse to the folder where you want to save your compiled website.
  5. It is the time to click on "Publish" button.

Now you can copy and paste these files any of the windows online server using any ftp client. Most of the developers are using "FileZilla" https://filezilla-project.org/download.php?type=client[^]
 
Share this answer
 
Comments
sudeshna from bangkok 12-Feb-15 4:56am    
I have visual studio 2010 ultimate. Is it ok then?
Mukesh_Chauhan 12-Feb-15 6:14am    
Yes, visual studio 2010 ultimate is fine for publishing the site
VPSingh malhi 12-Feb-15 6:22am    
Try with the same steps and follow the dialog box instructions. Process is same some of the messages will be bit different. Please use the link Publish a website for reference.
You need to install the database (MS SQL or MySQL) on the server and create the database 'InventoryDatabase' on the server and then use following connection string in the web.config


<add name="InventoryDatabaseConnectionString" connectionstring="Data Source=Name\INSTANCE;Initial Catalog=InventoryDatabase;Integrated Security=True" />



after that configure the webserver (IIS or Apache) for the website using the path where you copied the file on the server.
 
Share this answer
 
v2
Comments
sudeshna from bangkok 12-Feb-15 2:25am    
I have to install full sql server 2008 r2 in server?
sudeshna from bangkok 12-Feb-15 2:28am    
i have already inserted 500 records in my local db located in my system. how do i upload that db with records to server?
Mukesh_Chauhan 12-Feb-15 2:34am    
Yes, you need to install the full sql server and you can make a script to export those records and then import to the server database
Mukesh_Chauhan 12-Feb-15 2:38am    
You can also use"Import and Export Feature" of SQL Server Management Studio to import and export of data
sudeshna from bangkok 12-Feb-15 2:44am    
Ok. Then 1st i have to install sql server, then using the import and export feature i will import the data to server? Right? Then i will publish my project and the folder which will be created after publish, i will upload all the files to server.Right? Then i can give the same connection string which i have in my web.config. Correct?
Backup The Database of the Current system And Restore On The Server Database And Change The Connection String.set the connection string Of the Server.


C#
<add name="InventoryDatabaseConnectionString" connectionString="Data Source=serverip or Name\INSTANCE;Initial Catalog=InventoryDatabase;Integrated Security=True" />
 
Share this answer
 
v3
Comments
sudeshna from bangkok 10-Feb-15 22:10pm    
i dont have any data in the database. I had all the dummy data in my local database.So when i will make it live, i will remove all the data.

And what connection string will i set on the server.

Presently in my local DB.
<add name="InventoryDatabaseConnectionString" connectionstring="Data Source=.\INSTANCE;Initial Catalog=InventoryDatabase;Integrated Security=True">

this is the connection string written.

So next what do I do?
sudeshna from bangkok 10-Feb-15 23:28pm    
Can anyone please help me? I need to make my project live
Tushar sangani 12-Feb-15 1:20am    
add name="InventoryDatabaseConnectionString" connectionString="Data Source=ServereIP Or Name;Initial Catalog=InventoryDatabase;Integrated Security=True" />
sudeshna from bangkok 12-Feb-15 2:24am    
I have inserted 500 records in my local db which is there in my system. now next what do i do? to upload my db in server?
VPSingh malhi 12-Feb-15 6:26am    
Which dbserver you are using please tell about its version as well. Then someone will be able to suggest you how you can manage it?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900