Hello,

I've developed an application with Visual Web Developer 2005 Express and SQL Server Express 2005.

I have two databases: misdatos.mdf and ASPNETDB.MDF 

 Now I want to upload the application to a server but I don't know if I have to change something in the code or even to create a new database in the internet server.

Somebody can explain me what I have to do? (I'm a bit lost)

Thank you.
 

Hi tcblues,

Before you publish the web application to the Server, I think you should first notice the following information:

      1. What’s the SQL Server Edition on the Server?

The SQL Server Express is the next version of MSDE, and easy for new developers to use immediately. We will not install it on the production Server. So if there is other Edition of SQL Server installed on the Server, you should change the ConnectionString like this:

Data Source=CurrentServer;Initial Catalog= misdatos;Integrated Security=SSPI;

Or

Data Source= CurrentServer;Initial Catalog= misdatos;User Id=Username;Password=Password;

      2. Does the aspnetdb already in the SQL Server on the Server?

If the aspnetdb database doesn’t exist, you should run aspnet_regsql to create a new one in the SQL Server. Then import all the data from your current database file: aspnetdb.mdf.

If the database already exists, also import the data from aspnetdb.mdf.

At last, attach the misdatos.mdf in SQL Server.