| Author |
Topic |
|
blackX
Posting Yak Master
102 Posts |
 Posted - 2008-03-12 : 15:56:35
|
| My company has a proprietary database application that is the heart and soul of our company. We would like to deploy this application to remote users. What would be the best way to deploy it? The data would contain sales and personal data, so it is extremely sensitive. The database is SQL Server 2000 and the application was writen in VisualBasic 2003 and has since converted to 2005. I know a web app would be the best solution but it is not in the budget. Any ideas would be great. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-12 : 16:00:22
|
| To move your database, you can use BACKUP/RESTORE or detach/attach.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2008-03-12 : 16:02:55
|
quote:
Originally posted by tkizer
To move your database, you can use BACKUP/RESTORE or detach/attach.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
We would need the offsite employees to use the application at the same time when the corporate office was using it. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-12 : 16:12:45
|
| I don't understand what you mean.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2008-03-12 : 16:15:54
|
quote:
Originally posted by tkizer
I don't understand what you mean.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
SorryThe people offsite would be using it from 8am-5pm. Users in our corporate offices would be using it during the same hours. Currently the offsite users fax us the data and we then enter at our headquaters. We would like the offsite users to do their own data entry. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-12 : 16:40:29
|
| I guess I'm confused what you want in your original post then. I thought you wanted to deploy the database. If all you want to do is deploy an application, then what part are you having difficulty with in the installation?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-03-12 : 17:13:28
|
Tara,It sounds as if blackx is looking for options in terms of creating and deploying enterprise type applications that can be accessed from several geographically dispersed locations. One of the requirements I gleaned from his posts is that all locations need to access the same data. Here are several options (among many):- Deploy a web centralized based application over SSL
- Implement some sort of Citrix based solution over a secure connection
- Deploy the application and database separately across all locations and configure replication between the database servers to maintain the data across locations
There are probably other viable options but here are a few. |
|
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2008-03-12 : 17:51:29
|
quote:
Originally posted by tfountain
Tara,It sounds as if blackx is looking for options in terms of creating and deploying enterprise type applications that can be accessed from several geographically dispersed locations. One of the requirements I gleaned from his posts is that all locations need to access the same data. Here are several options (among many):- Deploy a web centralized based application over SSL
- Implement some sort of Citrix based solution over a secure connection
- Deploy the application and database separately across all locations and configure replication between the database servers to maintain the data across locations
There are probably other viable options but here are a few.
you are correct, that is exactly what we need. Sometimes I have a hard time typing what I am thinking. Those are pretty much the solutions we thought of. However the alternative locations are sales reps homes. We thought of a web app but the company has invested way too much money into their software and scapping it for a new application would be out of the question. We are trying to shy away from using the VPN because the reps home computers are not regulated by the company and our Network Admin is leary about opening up our network like that. Any other ideas? thanks for all the responses. |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-03-12 : 19:34:03
|
| If you don't want to look at using some sort of encrypted connection like a VPN then you need to investigate options over SSL. Possibly a web application over HTTPS or based on what type of firewall you have at corporate maybe a Citrix launched remote desktop session. I have one client that has a Cisco firewall and implemented a web based Citrix portal to launch remote desktop sessions. That was nice because I did not need to open a separate VPN connection, all the data actually stayed at the client site and still transmitted over a secure SSL connection.Another option is to design your application (I'm assuming it's a desktop application) to work 'offline' so to speak and synch changes when they login to the office. However this will require you to have a copy of the data on the laptops, probably not ideal for your situation.Hope these suggestions give you some ideas. |
|
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2008-03-12 : 20:04:29
|
quote:
Originally posted by tfountain
If you don't want to look at using some sort of encrypted connection like a VPN then you need to investigate options over SSL. Possibly a web application over HTTPS or based on what type of firewall you have at corporate maybe a Citrix launched remote desktop session. I have one client that has a Cisco firewall and implemented a web based Citrix portal to launch remote desktop sessions. That was nice because I did not need to open a separate VPN connection, all the data actually stayed at the client site and still transmitted over a secure SSL connection.Another option is to design your application (I'm assuming it's a desktop application) to work 'offline' so to speak and synch changes when they login to the office. However this will require you to have a copy of the data on the laptops, probably not ideal for your situation.Hope these suggestions give you some ideas.
thank you very much. I like your idea of the web based portal to launch a remote desktop. Can you give me more details on this? I think I can sell the idea of the data not leaving the internal network. Again thanks alot. |
|
|
|
|
Connecting to remote database