Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jake99
Starting Member
4 Posts |
 Posted - 2004-09-15 : 22:41:42
|
| Hello,We have an application that is running on a windows 2000 tablet pc. Currently the app (coded in vb.net) takes data from the access database (that resides on the tablet pc) and moves it to our Sql Server in the office via the internet as some staff are in different states. The application also transfers .jpg and .tif files between the server and the client. We are having issues with scalability due to the amount of growth we have been experiencing. Two years ago there was about 15 users running this application, now there are over 60, with growth expected to continue. My question is can MSDE help solve this problem. I was thinking that if I use MSDE on the client and tweak the application to store the .jpg and .tif files into the MSDE I could have SQL manage the replication. I know there is a limitation of 2 gigs on MSDE and we would make a temp db that the clients would replicate to and move the data up to the live database thus hopefully eliminating that issue. SO basically with the amount of data we are transferring can MSDE accomplish this with Sql Server at the office, thus eliminating our vb.net application? I was wondering if anyone had any thoughts on this. Thanks in advance.Jake |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-09-16 : 05:00:16
|
| You've identified that you have a problem....but I can't see that you hav pinpointed the key bottleneck. Is the issue data transfer time, or the scale/number of (manual) actions to be taken to transfer data (or support issues for a larger number of (untrained/unreliable) users)?If the former...moving images into MSDE won't change the amount of data to be transferred.If the latter...then advanced scripting might resolve it simpler.If the last lot...then a big stick (training program) might be cheaper!Storing images inside SQL is possible but not recommended....search here for more advanced commentary on this topic. Not sure if MSDE can replicate up with SQL....no experience with same. |
 |
|
|
|
|
|
Looking for suggestions