VB6 Application Install
From: DavidM (spam_at_spam.net)
Date: 12/03/04
- Next message: David D Webb: "Re: How can I Pass an array into a Stored Procedure from Visual Basic?"
- Previous message: Anith Sen: "Re: How can I Pass an array into a Stored Procedure from Visual Basic?"
- Next in thread: Stefan Berglund: "Re: VB6 Application Install"
- Reply: Stefan Berglund: "Re: VB6 Application Install"
- Reply: Nico: "Re: VB6 Application Install"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Dec 2004 11:44:35 -0600
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: David D Webb: "Re: How can I Pass an array into a Stored Procedure from Visual Basic?"
- Previous message: Anith Sen: "Re: How can I Pass an array into a Stored Procedure from Visual Basic?"
- Next in thread: Stefan Berglund: "Re: VB6 Application Install"
- Reply: Stefan Berglund: "Re: VB6 Application Install"
- Reply: Nico: "Re: VB6 Application Install"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
