Re: VB6 Application Install
From: Nico (nico_at_twister.d2g.com)
Date: 12/04/04
- Next message: Shawn Fessenden: "Re: Updating Tables"
- Previous message: Petrik Salovaara: "Re: VB6 Application Install"
- In reply to: DavidM: "VB6 Application Install"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 4 Dec 2004 13:02:46 +0100
I use InstallShield X to do the job. It can do all you want to do. And there
is a trial-version(works for 30 days). It is however a copple hundred megs
in size. It can create or update a SQL server database. It works with Oracle
SQL Server, MS SQL Server & MySQL Server. You can even specify which tables,
queries/views/stored procs you want to include in your database. If you want
the upgrade the sql server itself, I don't know how.
Nico.
"DavidM" <spam@spam.net> schreef in bericht
news: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.
>
- Next message: Shawn Fessenden: "Re: Updating Tables"
- Previous message: Petrik Salovaara: "Re: VB6 Application Install"
- In reply to: DavidM: "VB6 Application Install"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
