Re: VB6 Application Install

From: Stefan Berglund (keepit_at_in.thegroups)
Date: 12/03/04 

Date: Fri, 03 Dec 2004 12:44:49 -0800

On Fri, 3 Dec 2004 11:44:35 -0600, "DavidM" <spam@spam.net>
wrote:
 in <uqKPE$V2EHA.3416@TK2MSFTNGP09.phx.gbl>

>Hello - I have a VB6 application that I would like to create a SETUP program
>for using Inno. The question I have is that my application requires the
>ability to upgrade a SQL Server database, if needed, depending on the nature
>of the upgrade. I realize I can use SQLDMO to perform maintenance functions
>again SQL Server.
>
>How do professional applications handle this?
>
>My application may need to do the following the first time it is ever
>installed:
>
>1) Prompt user for SQL Server IP, Username, Password
>
>2) Create a Database if it does not already exist
>
>3) Create all tables
>
>4) Populate tables with data
>
>5) Create SQL Logins and assign users to database, if needed.
>
>6) Continue on with application SETUP... Setting Registry options, creating
>ODBC, install MDAC, etc.
>
>If doing an upgrade, there may be the possibility of:
>
>1) Verifying the SQL and Database exist.
>
>2) Check version # of database
>
>3) Attempt to update schema, TABLE ALTER, etc.
>
>4) Continue on with application SETUP... Setting Registry options, creating
>ODBC, install MDAC, etc.
>
>Any comments, suggestions, samples, etc., would be appreciated.
>

I wouldn't try to do the database creation during setup, but
rather when the installed program runs. I install an auxiliary
program which contains the compressed T-SQL scripts as well as
any initial data stored as resources within the exe. When the
program runs it shells to this auxiliary app to perform the
desired operations.

The second app is also handy if you'll be updating from the
Internet. 

---
Stefan Berglund

Relevant Pages

  • Re: SharePoint Services 3.0 unable to display content
    ... looking at the database table information, ... Microsoft Windows SharePoint Services 2.0 ... Can we asume you mean SQL Server 2005? ... The upgrade identified that there was a previous ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Upgrade from MSDE to SQL
    ... Hard to say whether the database is of any use to you now you are partway ... upgrade just in case. ... But FIRST I would in any case see if adding SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Cannot view DB properties
    ... # Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Server ... owner was NULL after the UPgraded finished successfully. ... The proposed new database owner is already a user or aliased in the ... Sorry, I don't understand, what do you mean by "In-Place Upgrade"? ...
    (microsoft.public.sqlserver.security)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Upgrade 2000 to 2005
    ... That way, if there is a failure in the upgrade process, you at ... Senior Database Administrator ... Real-world stuff I run across with SQL Server: ... side and move the databases but the hardware just aint there. ...
    (microsoft.public.sqlserver.clustering)