Adding database tables

Discussion in 'Databases' started by iguta, Mar 6, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. iguta

    iguta

    I am using SQL Server 2008 as my DB and have 4 sites that I need to upload to my newly created account. I followed the instructions provided by Mark's video http://iis7test.com/expresstools/Default.aspx, to upload and attached my SQL Express db for the first site. However, attaching the second db causes the first to be overwritten. So I gues I have 2 questions;
    1. How do I attach dbs or add tables for each of my 4 sites?
    2. How do I modify my connection string to specify which table each site should use?
    Kind regards.
     
    iguta, Mar 6, 2009
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    when you attach a database, it overwrite the existing content w/ the new one. Think of it as replacing the database file.

    > 1. How do I attach dbs or add tables for each of my 4 sites?

    You can add table by connecting to the database server using any SQL client like Management studio or the web interface (sqladmin)

    > 2. How do I modify my connection string to specify which table each site should use?

    You can't. Connection string specify connection to the database, you can't tell which table to use. This is handled by the code.
     
    Bruce, Mar 6, 2009
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page