what are the files need to upload for sql server database.

Discussion in 'C#' started by kharearch, Sep 24, 2008.

0
  1. #1
    In my website I am using sql server database. what are files need to upload for sql server database? Thanks.
     
    kharearch, Sep 24, 2008 IP
  2. yugolancer

    yugolancer Well-Known Member

    Messages:
    320
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #2
    If your question matter deploying an app to shared hosting environment then you don't need to upload anything. Rather you should generate SQL code for creating the tables and objects (SP, Views, Triggers etc.) and inserting the data into the new database.
    Some hosting companies allow you to use attached SQL Express database and therefore if you work with express you can simply upload entire "App_Data" directory including the database files as well.
     
    yugolancer, Sep 24, 2008 IP
  3. vihutuo

    vihutuo Well-Known Member

    Messages:
    1,511
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    180
    #3
    Check this article http://weblogs.asp.net/scottgu/arch...-and-execute-it-to-deploy-a-sql-database.aspx

    1. Generate the SQL scripts using the "Database Publishing Wizard"
    2. Upload the generated SQl file to your webhost
    3. Upload another file "RunSQL.aspx" which you will find in the above link ... Make sure you change the connection info and the name of the SQl file that you uploaded
    4. Using the webbrowser navigate to "RunSQL.aspx"
     
    vihutuo, Sep 26, 2008 IP