Upgrading SQL 2005 Express to full SQL 2005

Upgrading SQL 2005 Express to full SQL 2005

Post by Uri Diman » Fri, 09 Feb 2007 15:18:19


> 1. Can the full SQL 2005 accept the sa via the command line as we have

Yes, I have a Personal Edition and can succefully connect via sa thru
command line



Backup all user databases and restore on full sql server 2005. I believe
you can install a full SQL Server 2005 as a named instance co-exists with
SQL Server Express Edition


If you got Personal Edition for example why would you want to run it via a
command line? Can you elaborate a little bit?
 
 
 

Upgrading SQL 2005 Express to full SQL 2005

Post by bl9sbG95Z » Fri, 09 Feb 2007 16:33:01

hanks for your response.

Command line parameters from Template.ini supplied with QLEXPR.EXEand
Books online.

We are interested in the installation upgrade processes specifically not
with general database connection.

To clarify further We supply a desktop application using SQL MSDE/2005
Express as the database. We install our own named instance and restrict
access to the database via aONLY.

Our product bootstraps the nested Microsoft QLEXPR.EXEand passes via
command line as a silent install.

We wish to be able to allow our customers to pgradeto full SQL if or
when their databases or number of users are at a point that justifies this.

To allow this we have to provide a bootstrap to their SQL product that
validates their setup.exe and passes via command line the necessary
parameters to upgrade our named instance.

We have achieved this in a particular scenario. (SQL Express (no service
pack) to SQL 2005 Standard edition)

We have used the same command line parameters, that successfully installs
SQL Express, with the SQL 2005 Standard edition but it FAILS.

We do not want our users (if we can help it) to have to uninstall SQL
Express and re-install full SQL 2005 when Microsoft state it is possible to
simply upgrade. We also do not wish to expose the abut provide a
bootstrap for users to allow this upgrade to be automated.


We wish to use aonly with regard to upgrading SQL 2005.


You would expect ato have precedence over indows authentication


It appears that the Microsoft setup.exe for the full SQL product does in
fact NOT support the same command line parameters as documented for
SQLEXPR.EXE.

Regards


"Uri Dimant" w>o>e:

> > 1. Can the full SQL 2005 accept the sa via the command line as >e>have
> > successfully done with the SQL 2005 E>pre>s?
>
> Yes, I have a Personal Edition and can succefully connect via s> thru
> comma>d l>ne >>>
>
> > 2. How do you upgrade SQL 2005 Express SP2 to full SQL 2005? W>e>e is
> > the media, its not in our current MS>N k>t?
>
> Backup all user databases and restore on full sql server 2005. I b>lieve
> you can install a full SQL Server 2005 as a named instance co-exist> with
> SQL Server Express >dit>o>
>
> > 3. Is it possible to upgrade or perform a new installation via the >o>mand
> > line using the 'sa' password only (no windows authentic>tio>).
>
> If you got Personal Edition for example why would you want to run it>via a
> command line? Can you elaborate a litt>e b>t? >> >>
>
> "<_lloyd" < XXXX@XXXXX.COM >soft.com> wrote in m>ssage
> news:77713D6C-18F3-4210-851C-30497CDE58F2@microsoft>c>m...
> >I am trying to upgrade from SQL 2005 Express to full SQL 2005 us>n> the
> > command line option. Also, install a new full SQL 2005 using the c>m>and
> > >in>.> > >
> > I am using the same command line parameters, to install a new fu>l>SQL
> > >005,
> > that I use to successfully install a new SQL 2005 Express, w>t>out
> > s>c>es>.> >>>> > >
> > According to Microsoft they both should accept the same comma>d>line
> > para>e>er>.> >>>> > >
> > I have a script to validate a genuine Microsoft SQL 2005 setup.e>e>and
>>>>then
> > pass the command line. I can successfully upgrade from SQL 2005