Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
kfkenneth2001
Starting Member
12 Posts |
Posted - 2005-05-14 : 03:08:36
|
I have developed a application for 2 companies which use MSDE in the backend. The clients request for an installation package recently, can I include MSDE2000 or later SQL Express in my setup package?Thanks. |
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-14 : 13:55:25
|
If you're asking strictly from a licensing perspective, then the issue would be yes. Also, what do you mean by MSDE2000 as opposed to MSDE? What version of MSDE are you using now?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
kfkenneth2001
Starting Member
12 Posts |
Posted - 2005-05-17 : 23:55:16
|
Does the version of MSDE affect the license? I only want to refer to the MSDE having the same engine with SQL Server 2000.Is there any registration I need to make as I am going to distribute database engine.Thanks. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-05-18 : 00:07:32
|
you can bundle MSDE with your app without worrying about any licensing issues. keep in mind that MSDE has some limitations:1. Limited to 2GB database size2. Limited to 2GB RAM3. Workload governor4. lacking most SQL client tools (no EM, QA, books online, profiler etc.)there are more limitations, but these are the major ones that I can think of.There are 3 versions of MSDE so far, MSDE 1.0 (which was based upon SQL 7.0), MSDE 2000 (which is based on the SQL 2000 codebase) and SQL Express (based on SQL 2005).SQL Express is a little more limited than MSDE 2000 in some ways, and more capabable in other ways. Microsoft switched things up a bit just to keep us on our toes.1. Limited to 1 CPU2. Limited to 1 GB buffer cache3. 4GB database size4. no workload governor5. No SQL server agent (no scheduler)6. GUI management tools are now included (Express Manager)Again, there are more differences and limitations, but these are the ones that come to mind.-ec |
|
|
kfkenneth2001
Starting Member
12 Posts |
Posted - 2005-05-18 : 00:31:05
|
Thanks a lot! I got much less worry about the license now. |
|
|
|
|
|
|
|