How to install sql 2008

[NewsArchive]

Hi,

I need to install
-sql 2008 express,
-a backup of a database (with initial tables data),
-my app

How to do a rock hard installer avoiding no understandable messages to the
user, etc, and survive?

Saludos / Regards,

Alberto Michelis
ARMi software solutions
www.armi.com.ar

[NewsArchive]

The short answer is 'Good luck'..
I have a thread with app. the same content (2005 instead of 2008), and it
has got zero (0) answers.

I will begin to make it next week - I will try to shore what I find out
here.

Edvard Korsbæk

[NewsArchive]

mmhhh
If there is no way then SB is not the right way to go with apps that uses
sql driven files.
This is a big problem because all modern apps uses sql and the user does not
need to know how to install the sql server, to restore the basic database,
etc.
I belive there must be a way with SB
Friedrich?

--

Saludos / Regards,
Alberto Michelis
ARMi software solutions
www.armi.com.ar

[NewsArchive]

Alberto,

Hmm, "not the right way to go"? No idea what you mean. SetupBuilder can
install whatever you want. No limit here.

SQL Server is installed via a Microsoft redistributable -- there is no other
way nor is it allowed to use another method to redistribute it. So you only
have to download and use that redistributable from Microsoft and you are
done.

The same is true for SQL 2005.

Hope this helps.

BTW, in the last 12 weeks alone, our Consulting did four large projects with
SQL Server deployment. No problem at all.

Friedrich

[NewsArchive]

Ok, greate!
May you please post an example of how to deal with the M$ redistributable
and how to restore a basic database?

--

Saludos / Regards,

Alberto Michelis
ARMi software solutions
www.armi.com.ar

[NewsArchive]

> Ok, greate!
> May you please post an example of how to deal with the M$ redistributable
> and how to restore a basic database?

Well, there is a full featured SQL Express 2005 include script available
(including a SQL 2005 Express Core PreRequisite). You can use a similar
method for SQL Server 2008.

So as a starting point, I would suggest to study the SQL Server 2005 include
script to learn the basics of Microsoft redistributable deployment. All
Microsoft redistributables make use of the same (or a similar) command line
calling method.

BTW, and I would strongly suggest to learn the basics of SQL Server
deployment in general (e.g. from MSDN). Without that background
information, it's not a good idea to distribute any SQL stuff to customers!

Friedrich

[NewsArchive]

Of cause you are right, that the 'Instalbuilder' is the way to go.
A large project with MSSQL deployment is no particular problem. In the other
end there is an IT pro, which understands what we want done.
But a small project, where the other end is an 52 year old woman, which find
it impossible to save a word document to anywhere else than 'Documents'
(With no backup...), thats a challenge.
It needs to be totally 'silent', and if possible the only page the customer
will see is the 'Wellcome' and the 'Eula'.
If that can be done - I an not a pro with the setups for MSSQL - I am sure
that SB6/7 can do it.
The project Alberto describes is very similar to my job, and an example
showing the parameters to use would be very helpfull.
I see that the mssql 2005 express redistibutable is in the redistributable
manager - The 2008 could perhaps be good to have there is well.

When/if i get a mssql 2005 express server installed silent, I will make it
into an .SBI script.

Edvard Korsbæk

[NewsArchive]

I want to say, that I had not read your answer to Alberto before my
comment.
It seems like it answers all my demands.

Edvard Korsbæk

[NewsArchive]

Edvard,

> I see that the mssql 2005 express redistibutable is in the
> redistributable manager - The 2008 could perhaps be good to have there is
> well.

There are some threads with regard to this. SQL Server 2008 requires quite
a few dependency redistributables (IIRC, in total, more than 300 MB!).

Because of this download overhead nightmare, it will not be available in the
Redistributable Manager.

The same is true for the latest SQL Server 2005 with Advanced Services
SP3 -- more than 240 MB overhead. Unbelievable but true.

Friedrich