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 |
|
Grimlock
Starting Member
3 Posts |
 Posted - 2007-02-11 : 01:20:39
|
| Hello, thanks for reading this.I am trying to learn a bit about debveloping my own website, and I am in need of a basic direction on how to acomplish this task:I have an local program running on my PC that creates an MS Access database export of my inventory. This export can be directly uploaded to my web server in a zip format.My web site is developed in Coldfusion MX7, and uses a MS SQL 2005 database. What I would like to do is create somewhat of an "Auto update" for my website, exporting my access database and updating the MS SQL database automatically. I really can use some good direction on this problem.Thank you for any help in advance. |
|
|
Grimlock
Starting Member
3 Posts |
Posted - 2007-02-11 : 01:24:50
|
| Sorry, forgot to add..When I add, update, or delete an product on the Access database, I would need the same action done on my web servers MS SQL database also. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-11 : 05:27:18
|
| Assuming that the data, in the database, will not change at the Web site end then I think the easiest would be to just transfer all the tables each time.You need to think a bit about how your website will behave whilst this action is "in progress" - there may be inconsistencies depending on the order the tables are uploaded - e.g. a Product record exists, but its Stock level record isn' there yet ...An alternative would be to install SQL Server on your local PC and then "up-size" your Access application so that the data was stored in SQL Server, but the "application" continues to be stored in Access.You could then just transfer the whole SQL Server database from your PC to the web - which ought to offer:1. More control over the update2. More robustness - no change of datatype precision which might induce some bugsKristen |
|
|
|
Grimlock
Starting Member
3 Posts |
Posted - 2007-02-11 : 10:41:57
|
| Kristen, I think doing the change locally would be the best choice for the time being.The only concern I have is that the data locally on my Access database contains other information such as employee records, and they do not need to be placed on my website. Is it possible to have the SQL server only update certain records only? I beleive it would be, for instance I have 5 tables on the server, and I only need to update 2 of them.. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-11 : 12:04:06
|
| The would rule up just "uploading the whole database", so instead you could set up a transfer to just upload the 2 tables.Kristen |
|
|
|
|
|
|
|
|
Can someone point me in the right direction?