APP_Data and sql server

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Ilyas

    APP_Data and sql server

    Hi

    I f I place an .mdf file inside the App_data to deploy a web app - can
    I deply my site so that the database at runtime is picked up in the
    App_data directory?

    Would my server need to have sql server installed for this to work or
    just the .net framework?

    Is the above possible - if not what is the purpose of App_data?
  • Michael Nemtsev [MVP]

    #2
    Re: APP_Data and sql server

    Hello Ilyas,

    your MDF should store somewhere in hard drive.
    u can use the App_data but in SQL server u should import that DB from you
    app_data forlder to work with this database from sql server

    ---
    WBR,
    Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

    "The greatest danger for most of us is not that our aim is too high and we
    miss it, but that it is too low and we reach it" (c) Michelangelo


    IHi
    I>
    II f I place an .mdf file inside the App_data to deploy a web app -
    Ican I deply my site so that the database at runtime is picked up in
    Ithe App_data directory?
    I>
    IWould my server need to have sql server installed for this to work or
    Ijust the .net framework?
    I>
    IIs the above possible - if not what is the purpose of App_data?
    I>


    Comment

    • gnewsgroup

      #3
      Re: APP_Data and sql server

      Michael Nemtsev [ MVP ] wrote:
      Hello Ilyas,
      >
      your MDF should store somewhere in hard drive.
      u can use the App_data but in SQL server u should import that DB from you
      app_data forlder to work with this database from sql server
      >
      ---
      WBR,
      Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour
      >
      "The greatest danger for most of us is not that our aim is too high and we
      miss it, but that it is too low and we reach it" (c) Michelangelo
      >
      >
      IHi
      I>
      II f I place an .mdf file inside the App_data to deploy a web app -
      Ican I deply my site so that the database at runtime is picked up in
      Ithe App_data directory?
      I>
      IWould my server need to have sql server installed for this to work or
      Ijust the .net framework?
      I>
      IIs the above possible - if not what is the purpose of App_data?
      I>
      I think what he was asking is this: will his mdf db file work properly
      with his web app on the production sever if the production server does
      not have sql sever installed?

      Comment

      • Ilyas

        #4
        Re: APP_Data and sql server

        Yes

        this is exactly what I am asking - wil it work?

        On Feb 22, 4:09 am, gnewsgroup <gnewsgr...@gma il.comwrote:
        Michael Nemtsev [ MVP ] wrote:
        >
        >
        >
        >
        >
        Hello Ilyas,
        >
        your MDF should store somewhere in hard drive.
        u can use the App_data but in SQL server u should import that DB from you
        app_data forlder to work with this database from sql server
        >
        ---
        WBR,
        Michael  Nemtsev [.NET/C# MVP] :: blog:http://spaces.live.com/laflour
        >
        "The greatest danger for most of us is not that our aim is too high and we
        miss it, but that it is too low and we reach it" (c) Michelangelo
        >
        IHi
        I>
        II f I place an .mdf file inside the App_data to deploy a web app -
        Ican I deply my site so that the database at runtime is picked up in
        Ithe App_data directory?
        I>
        IWould my server need to have sql server installed for this to work or
        Ijust the .net framework?
        I>
        IIs the above possible - if not what is the purpose of App_data?
        I>
        >
        I think what he was asking is this: will his mdf db file work properly
        with his web app on the production sever if the production server does
        not have sql sever installed?- Hide quoted text -
        >
        - Show quoted text -

        Comment

        Working...