I wold be carefull with the create database task. This will NOT Scale into enterprise environments.
I normally keep database creation AND population to a separate small tool. Reason: In enterprise environments the people running the db setup (retion, rights) are not the people installing software and MAY want to tune it (locations, number of files etc.).... unless it is a trivial thing to do. That said I mostly work into larger databases (1000+gb) that require carefull adjustment of the physical layout. Regards Thomas -----Original Message----- From: Dikhi Wahyudi Aras [mailto:[email protected]] Sent: 29 March 2011 04:45 To: [email protected] Subject: [WiX-users] Best Practice in Deploying Database Hi there, I have scenario where my product supports several database servers (SQL Server, MySQL, Oracle). What would be the best practice in deploying the database for my products using WiX? I am thinking to build custom user interface in WiX for the user to select the type of database and then connection information. With that information we could run the database script to : - Create Database - Create Database Objects (Tables,etc.) - Generate Default Data I would appreciate if someone could lead me to a WiX extension available to do the above tasks. And I understand that WiX is currently only supporting database deployment to SQL Server Database. Many thanks, Dikhi ------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ WiX-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ WiX-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users
