SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Sep 2002
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Licensing Question

    Hello,

    I'm trying to understand the different licensing options for SQL Server. I am a one-person web-development operation, so my needs ar fairly minimal. I have a SQL Server account with my web hosting company.

    If I understand correctly, I should be able to use the Developer edition to create databases on my desktop and export/migrate them to my host. Is that correct?

    I need to be able to connect and move data between my desktop and a server on the internet. Will the Developer Edition allow this?

    Also, I've been using the trial version of Embarcadero's dbartisan. It's very nice, but at $1,800 well beyond my budget. I've used it mainly as a replacement for Enterprise Manager to build, test, and migrate tables. Is there any comparable software package available for a lower price?

    Thanks for your help.

    John

  2. #2
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    To answer your first question,

    Yes, you can develop databases using the MSDE and then transfer them to the "big boy" database. You will need to get ahold of Enterprise Manager to do this though (or dbartisan of course).

    Secondly, dbartisan is 2K? Wow, I don't think it's worth 2K personally...
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  3. #3
    SitePoint Member
    Join Date
    Sep 2002
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    enterprise manager

    Thank you.

    Enterprise Manager is part of the Developer Edition package, isn't it?

    I have a SQL 7 cd now that allows me to create databases, but I can't migrate or export them using DTS. It does have Enterprise Manager though...

    John

  4. #4
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Enterprise Mgr of Ms Sql 7.0 cannot be used to manage Ms Sql 2000 databases

  5. #5
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SQL Server 2000 Developer Edition is only $499 US per developer
    http://www.microsoft.com/sql/howtobuy/development.asp

    Or... you could use the 120-day trial - and reinstall 3 times a year
    http://www.microsoft.com/sql/howtobuy/trial.asp


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
  •