I have created pages in asp.net and used backend SQL Server 2000. i want to upload all asp.net contents and sql server 2000 database to internet.

i dont have an idea. i have not yet deployed the contents, deploying contents is must or we can just upload all file. pleaseeeeeeeeeeeeeeeeeeee give me suggession.

Hi,

In Visual Studio select the option Build >> Publish Website from the menu. I will open a popup which will ask you few things including target folder. Pressing the button will copy only those files in the target folder that will be required to upload on the webserver. For Sql Server 2000 use your Enterprise Manager. Right Click on the Database and select All Tasks then select Export Data. It will open a wizard in which you have to give the credentials and the database name of the local computer when you click next you will then have to give the credential and the database name of the webserver. When you click next you will see 3 options select “Copy objects and data between Sql Server databases” and click next. It will then ask you some more things like what you want to copy. Then click run immidiately. It will start transfering the complete database.