STILL bad. Any idea how complicatd it can be in companies to get admin rights on sql server for installing a server application? It can be living hell.
At least allow using an EXISTING empty database - so the dba's can set up the database, then you use the given username and password to initialize the tables etc. I ran into exactly the problem once at a customer site. Took 3 days to install an application nbecasue the admins only gave "Minimal really minimal permissions on sql server" and the installer insisted on doing everything in one run. This was running circles around middle management. -----Original Message----- From: Dikhi Wahyudi Aras [mailto:dikhi.wahy...@mitrais.com] Sent: 29 March 2011 09:27 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Best Practice in Deploying Database Thank you Thomas for sharing your thought. I agree with you to separate the database deployment with the client application installation. In my situation however, we plan to put database deployment together with the server-side deployment. The client-side application deployment doesn't perform such action. Probably the trivial thing on deploying database is that the degree of control to create database is different from a database to database. As you said, you may want to tune your database in more detail during the database creation. So I guess the situation is that I could put the procedure of creating database outside the installation process, but will it scalable enough to let the database population to be done from my server-side installation process (ie. prompt the user for connection information to the newly-added database instance, and then execute the DDL script to populate the database)? Thank you, Dikhi -----Original Message----- From: Thomas Tomiczek [mailto:t.tomic...@nettecture.com] Sent: Tuesday, 29 March 2011 1:11 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Best Practice in Deploying Database 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:dikhi.wahy...@mitrais.com] Sent: 29 March 2011 04:45 To: wix-users@lists.sourceforge.net 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 WiX-users@lists.sourceforge.net 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 WiX-users@lists.sourceforge.net 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 WiX-users@lists.sourceforge.net 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 WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
