Wednesday, March 7, 2012

Express, Can I really redistribute this with our app?

SQL 2005 Express, Can I really redistribute this with our app?
Background: We sell a software program to Fortune 1000, always previously
required clients to use or obtain at least SQL 2000 Standard, always a
tedious process on their end, ie budgets, licensing, IT folks, etc.
Our typical client site has about 10 users who use our program, and the SQL
DB on some nearby host server.
Our DB requirements fit Express such as size < 4GB and Ram < 1GB. We don't
do anything too fancy with the DB, about 70 tables, 70 triggers, 140 stored
procedures. We use an embedded ID & PW passed by application, so SQL Login
has to be in there, but we can probably be flexible here.
Is SQL Express really a deployable solution for us? I assume that we can
script stuff like DB creation along with Tables and other needed objects,
allowing a typcial small group of users to get up and running quickly.
Can the DB host be an XP o/s in this scenerio? Do we need Management
Studio Express ?
From what I've read up at ms.com, all of this seems possible, I just can't
believe it would be this easy.
Any and all comments will be greatly appreciated."John" <John@.discussions.microsoft.com> wrote in message
news:936531F0-26FF-432E-A783-AD8264CE486A@.microsoft.com...
> SQL 2005 Express, Can I really redistribute this with our app?
> Background: We sell a software program to Fortune 1000, always previously
> required clients to use or obtain at least SQL 2000 Standard, always a
> tedious process on their end, ie budgets, licensing, IT folks, etc.
> Our typical client site has about 10 users who use our program, and the
> SQL
> DB on some nearby host server.
> Our DB requirements fit Express such as size < 4GB and Ram < 1GB. We
> don't
> do anything too fancy with the DB, about 70 tables, 70 triggers, 140
> stored
> procedures. We use an embedded ID & PW passed by application, so SQL
> Login
> has to be in there, but we can probably be flexible here.
> Is SQL Express really a deployable solution for us? I assume that we can
> script stuff like DB creation along with Tables and other needed objects,
> allowing a typcial small group of users to get up and running quickly.
> Can the DB host be an XP o/s in this scenerio? Do we need Management
> Studio Express ?
> From what I've read up at ms.com, all of this seems possible, I just can't
> believe it would be this easy.
> Any and all comments will be greatly appreciated.
>
Yep, it's that easy. You need to register for redistribution rights
(http://www.microsoft.com/sql/editio...stregister.mspx).
Of course your customers might want to deploy your app on a higher SKU of
SQL Server, and they can always upgrade later.
David|||Thanks David for confirming its that easy.
How about the Windows XP host PC? Is that OK with say about 10 users
accessing data?
And Management Studio Express ? Is a gold release out yet or still CTP?
I'm figuring we'd need to use this for deployment or at least make it
available for clients just in case.
Again, your comments are valuable and appreciated!
John|||"John" <John@.discussions.microsoft.com> wrote in message
news:08D225AB-CB1E-44E4-BF80-D831FA3D57F8@.microsoft.com...
> Thanks David for confirming its that easy.
> How about the Windows XP host PC? Is that OK with say about 10 users
> accessing data?
It will install fine, but SQL Server is a server product, and you should
really run it on a server OS. Even though you don't have to pay a lot for
it you should take the deployment decisions seriously. Especially with
Fortune 1000 customers, their XP desktops are probably managed in a way that
makes them unsuitable for running a server product. Run Windows 2003
Server.

> And Management Studio Express ? Is a gold release out yet or still CTP?
> I'm figuring we'd need to use this for deployment or at least make it
> available for clients just in case.
For development get your staff MSDN or SQL Server Developer Edition. This
will give you full access to all the tools. You can use Management Studio
Express manage your deployed instances.
David

No comments:

Post a Comment