This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- FlexNet Connect
- :
- FlexNet Connect Forum
- :
- Re: Can Update Service be used to update data in the client's database?
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Sep 20, 2005
05:30 AM
Can Update Service be used to update data in the client's database?
Hi,
I want to develop an installer for my software. The requirements for my software installation are:
1. Copy the source code files on the client’s machine
2. Configure a particular folder (in my source code files) as a virtual directory in the IIS.
3. Configure XML files according to the input provided by the user during the installation.
4. Restore a Database Backup on the SQL Server 200 and after restoring run a few SQL Scripts on the same.
5. Most Important I want to update the data in the client’s database (SQL Server 2000) as a part of my software upgrades that too over the Internet.
I wanted to know that using the Update service can I do the activity mentioned in point 5 and which version of the Install Shield would be required for developing the installer and the updates for the same later "Install Shield Professional Edition" or "Install Shield Premier Edition".
I would really appreciate if robert you could look into my problem and suggest.
Thanks,
Sidharth
I want to develop an installer for my software. The requirements for my software installation are:
1. Copy the source code files on the client’s machine
2. Configure a particular folder (in my source code files) as a virtual directory in the IIS.
3. Configure XML files according to the input provided by the user during the installation.
4. Restore a Database Backup on the SQL Server 200 and after restoring run a few SQL Scripts on the same.
5. Most Important I want to update the data in the client’s database (SQL Server 2000) as a part of my software upgrades that too over the Internet.
I wanted to know that using the Update service can I do the activity mentioned in point 5 and which version of the Install Shield would be required for developing the installer and the updates for the same later "Install Shield Professional Edition" or "Install Shield Premier Edition".
I would really appreciate if robert you could look into my problem and suggest.
Thanks,
Sidharth
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Sep 20, 2005
07:05 AM
Well, you can use the Update Service regardless of which installer tool you choose.... the InstallShield IDEs just happen to make it more simple to include the service with your installation. You'll probably want to post your setup-related question to the InstallShield 11 community, or check with a product consultant if you choose Macrovision installer technology....
In terms of updating the database, the Update Service can handle it. However, please be aware that the update service will grab your update and execute it on the local machine, be it server or desktop. So it's really for your update package to know how to connect to the MSSQL server & run the SQL script. In short, the Update Service will ensure that your update is sent to the proper client machines and executed, but it's still your update package which defines what you want to happen.
Just my $.02....
Regards,
Kelly
In terms of updating the database, the Update Service can handle it. However, please be aware that the update service will grab your update and execute it on the local machine, be it server or desktop. So it's really for your update package to know how to connect to the MSSQL server & run the SQL script. In short, the Update Service will ensure that your update is sent to the proper client machines and executed, but it's still your update package which defines what you want to happen.
Just my $.02....
Regards,
Kelly
![](/skins/images/CC38E504FC9E1309DC48ACFEB4925670/responsive_peak/images/icon_anonymous_message.png)