Microsoft SQL Desktop Engine - using

  • Thread starter Thread starter 1qa2ws
  • Start date Start date
1

1qa2ws

Hi,

who can use MSDE 2000? If I develope an application with C# having MS Visual
C# .NET 2003 Standard which uses SQL Server, can I distribute my application
with MSDE?

1qa2sw
 
Yes, you should be able to use MSDE 2000. However, depending on the
needs of your application, you might not be able to use it (I think there
are limitations on connections, processors, and some other ones, you have to
check) depending on how much your application needs to do.

Hope this helps.
 
Nicholas Paldino said:
Yes, you should be able to use MSDE 2000. However, depending on the
needs of your application, you might not be able to use it (I think there
are limitations on connections, processors, and some other ones, you have
to check) depending on how much your application needs to do.

Hope this helps.
Click to expand...


1) Where can I find MSDE limitations?
2) Can I distribute MSDE having Standard License? The buyer of my
application doesn't have the SQL server, so he needs something, so I want to
install him the MSDE. Can he use it?

1qa2ws
 
Actually, you should be using SQL Server Express (a new product
offering). It is free, but has some limitations (1 GB RAM, 1 processor, 4GB
db size). You can find it at:

http://lab.msdn.microsoft.com/express/sql/

Also, there is a link to a features page which you can see the
limitations, but it should suit your needs.
 
The problem is that the server where it should be installed has 2GB RAM...

1qa2sw

Nicholas Paldino said:
Actually, you should be using SQL Server Express (a new product
offering). It is free, but has some limitations (1 GB RAM, 1 processor,
4GB db size). You can find it at:

http://lab.msdn.microsoft.com/express/sql/

Also, there is a link to a features page which you can see the
limitations, but it should suit your needs.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)
1qa2ws said:
1) Where can I find MSDE limitations?
2) Can I distribute MSDE having Standard License? The buyer of my
application doesn't have the SQL server, so he needs something, so I want
to install him the MSDE. Can he use it?

1qa2ws
Click to expand...
Click to expand...
 
The question is if the limitations are only support limitation or license
limitation. If the software suppoer 1GB RAM but works on 2GB RAM server and
it is legally, that's fine...

1qa2ws
Nicholas Paldino said:
Actually, you should be using SQL Server Express (a new product
offering). It is free, but has some limitations (1 GB RAM, 1 processor,
4GB db size). You can find it at:

http://lab.msdn.microsoft.com/express/sql/

Also, there is a link to a features page which you can see the
limitations, but it should suit your needs.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)
1qa2ws said:
1) Where can I find MSDE limitations?
2) Can I distribute MSDE having Standard License? The buyer of my
application doesn't have the SQL server, so he needs something, so I want
to install him the MSDE. Can he use it?

1qa2ws
Click to expand...
Click to expand...
 
You can still install it, you just won't be able to take advantage of
the full 2 GB of RAM.

If you want to take advantage of a machine which that much RAM, then you
will have to get a SQL server license.

Or, you could use alternatives to SQL server, like mySql. However, I
can't really speak for the capabilities, or ease of use in .NET.

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

1qa2ws said:
The problem is that the server where it should be installed has 2GB RAM...

1qa2sw

Nicholas Paldino said:
Actually, you should be using SQL Server Express (a new product
offering). It is free, but has some limitations (1 GB RAM, 1 processor,
4GB db size). You can find it at:

http://lab.msdn.microsoft.com/express/sql/

Also, there is a link to a features page which you can see the
limitations, but it should suit your needs.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)
1qa2ws said:
in message Yes, you should be able to use MSDE 2000. However, depending on the
needs of your application, you might not be able to use it (I think
there are limitations on connections, processors, and some other ones,
you have to check) depending on how much your application needs to do.

Hope this helps.


1) Where can I find MSDE limitations?
2) Can I distribute MSDE having Standard License? The buyer of my
application doesn't have the SQL server, so he needs something, so I
want to install him the MSDE. Can he use it?

1qa2ws
Click to expand...
Click to expand...
Click to expand...
 
I'm not sure exactly what the limitations of MSDE are, but I have some
co-workers that have pushed it pretty hard and was told the limitations
weren't quite as bad as MS tries to make them out to be. I don't have any
first-hand experience so I can't say for sure, but I think you might want to
test first.

That said, you want to stay within the licensing and that's probably where
the limitations are more than in the code since MSDE really is just MS Sql
Server without the client-side tools.

Pete

Nicholas Paldino said:
Actually, you should be using SQL Server Express (a new product
offering). It is free, but has some limitations (1 GB RAM, 1 processor, 4GB
db size). You can find it at:

http://lab.msdn.microsoft.com/express/sql/

Also, there is a link to a features page which you can see the
limitations, but it should suit your needs.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)
1qa2ws said:
1) Where can I find MSDE limitations?
2) Can I distribute MSDE having Standard License? The buyer of my
application doesn't have the SQL server, so he needs something, so I want
to install him the MSDE. Can he use it?

1qa2ws
Click to expand...
Click to expand...
 
Or, you could use alternatives to SQL server, like mySql. However, I
can't really speak for the capabilities, or ease of use in .NET.
Click to expand...

I can! mySQL is a wonderful product, so long as you require only "standard"
RDBMS functionality i.e. the storage and retrieval of relational data. In
that case, it has several huge advantages over SQL Server, Oracle, Sybase
etc...

1) It's free! And, at the risk of repeating myself, IT'S FREE!!!

2) Due to its (relatively!) restricted functionality, it's extremely fast -
even *performant*, as our American friends are wont to say... :-) Currently
at version 4.1, version 5.0 will have support for stored procedures and
triggers.

3) There is an excellent native .NET data provider available from CoreLabs,
which already supports version 2 of the .NET Framework.

For more information, check out these links:

http://www.mysql.com/products/mysql/
For the database engine itself, including feature comparisons with lots of
other RDBMS.

http://www.navicat.com/
For a management front-end, akin to SQL Server Enterprise Manager

http://crlab.com/mysqlnet/
For the native .NET data provider.
 
Back
Top