SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: SQL 7 and MSDE

Hybrid View

  1. #1
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question SQL 7 and MSDE

    can msde be used locally for development and then upload that to SQL 7 on the web?

  2. #2
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    Join Date
    Dec 2001
    Location
    erie, pa
    Posts
    1,130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yes it can be used for development. if by "upload to SQL 7" you mean copy your database structure/data from MSDE to SQL Server then yes to that as well.

  3. #3
    SitePoint Wizard Goof's Avatar
    Join Date
    Feb 2001
    Location
    Pittsburgh, PA
    Posts
    1,154
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am quickly coming to love MSDE. It's great for development or even deployment purposes. You can even run multiple servers on the same machine!

    Goof
    Nathan Rutman
    A slightly offbeat creative.

  4. #4
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    Join Date
    Dec 2001
    Location
    erie, pa
    Posts
    1,130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yes. if one is aware of the limitations of MSDE (such as performance decrease after 5 ocncurrent connections and a 2GB per db size limit) and properly builds an application to avoid these limitations, it is an excellent choice as a small scale production server, especially for intranet apps that won't have many connections.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •