Click here to Skip to main content
16,004,991 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
QuestionCreation of DB table at Installation Pin
__yash__19-Aug-07 22:05
professional__yash__19-Aug-07 22:05 
AnswerRe: Creation of DB table at Installation Pin
Hamid_RT20-Aug-07 0:17
Hamid_RT20-Aug-07 0:17 
AnswerRe: Creation of DB table at Installation Pin
David Crow20-Aug-07 2:54
David Crow20-Aug-07 2:54 
GeneralRe: Creation of DB table at Installation Pin
__yash__20-Aug-07 19:12
professional__yash__20-Aug-07 19:12 
GeneralRe: Creation of DB table at Installation Pin
__yash__20-Aug-07 20:59
professional__yash__20-Aug-07 20:59 
QuestionRe: Creation of DB table at Installation Pin
David Crow21-Aug-07 2:38
David Crow21-Aug-07 2:38 
AnswerRe: Creation of DB table at Installation Pin
__yash__21-Aug-07 3:04
professional__yash__21-Aug-07 3:04 
AnswerRe: Creation of DB table at Installation Pin
James R. Twine20-Aug-07 3:12
James R. Twine20-Aug-07 3:12 
   I would suggest getting a "real" installer system!  For example, Wise Installer (as of at last 4 years ago) was capable of installing databases and related items (SPs, views, users, logins, etc.) into an RDBMS.

   Short of that, you can just create a little application that contains all of the SQL you need to deploy your entire schema and knows how to connect to your target RDBMS(es) and can execute the SQL.  You can then have your installer launch it during installation (and during uninstallation for cleanup if necessary) to install the database for you.

   One thing I did previously was to put the DB installation logic into the application itself, and the first time it ran and noticed the database was not in the specified RDBMS, it installed it.  Sounds a bit kludgy, but it worked well for targeting multiple RDBMSes (QA, staging and production) from a single installation of the application.

   Peace!

-=- James
Please rate this message - let me know if I helped or not!<HR>If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong!
Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road!
See DeleteFXPFiles

GeneralRe: Creation of DB table at Installation Pin
Mark Salsbery20-Aug-07 8:25
Mark Salsbery20-Aug-07 8:25 
GeneralRe: Creation of DB table at Installation Pin
__yash__20-Aug-07 19:19
professional__yash__20-Aug-07 19:19 
AnswerRe: Creation of DB table at Installation Pin
__yash__20-Aug-07 22:12
professional__yash__20-Aug-07 22:12 
QuestionParallel port access in Win XP Pin
mirispearl19-Aug-07 21:08
mirispearl19-Aug-07 21:08 
AnswerRe: Parallel port access in Win XP Pin
Iain Clarke, Warrior Programmer20-Aug-07 0:27
Iain Clarke, Warrior Programmer20-Aug-07 0:27 
AnswerRe: Parallel port access in Win XP Pin
kakan20-Aug-07 0:31
professionalkakan20-Aug-07 0:31 
GeneralRe: Parallel port access in Win XP Pin
mirispearl3-Sep-07 0:25
mirispearl3-Sep-07 0:25 
GeneralRe: Parallel port access in Win XP Pin
kakan3-Sep-07 0:31
professionalkakan3-Sep-07 0:31 
QuestionMSMQ Pin
abhiramsss19-Aug-07 20:57
abhiramsss19-Aug-07 20:57 
AnswerRe: MSMQ Pin
Hamid_RT19-Aug-07 21:53
Hamid_RT19-Aug-07 21:53 
QuestionRe: MSMQ Pin
David Crow20-Aug-07 2:51
David Crow20-Aug-07 2:51 
QuestionGet problem with FindWindow(). Pls help! [modified] Pin
aluisdo19-Aug-07 20:31
aluisdo19-Aug-07 20:31 
QuestionRe: Get problem with FindWindow(). Pls help! Pin
prasad_som19-Aug-07 21:38
prasad_som19-Aug-07 21:38 
AnswerRe: Get problem with FindWindow(). Pls help! Pin
aluisdo20-Aug-07 1:46
aluisdo20-Aug-07 1:46 
GeneralRe: Get problem with FindWindow(). Pls help! Pin
prasad_som20-Aug-07 2:20
prasad_som20-Aug-07 2:20 
AnswerRe: Get problem with FindWindow(). Pls help! Pin
Hamid_RT19-Aug-07 21:59
Hamid_RT19-Aug-07 21:59 
GeneralRe: Get problem with FindWindow(). Pls help! Pin
aluisdo20-Aug-07 1:41
aluisdo20-Aug-07 1:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.