Updating database from my local SQL server

Hi

I have an Access database in my App_Data folder. This has a table called Parts...

When a part is displayed on my site, I would like to have something next to it to display if it's in stock or not...

All my parts info is stored on an SQL server in my office. I was thinking of having an update query run every 5 mins or so that it updated the stock on the Access database on the server. This is probably the wrong way of going about this (even if I knew how to do it!)...

Can anyone give me some help / advice on how to achieve this..?

Cheers

Luke

 

Hi,
If you really need to do this the local to remote method will need to be SQL Server to SQl Server.
You can however pull it off with Access if you have a DASP SQL Server.
Could work like this with no trouble:
1) Locally you pump updates to a DASP SQL Server.
2) You hit an Admin page on your site that pulls those updates over to your remote site Access DB.

I've done it that way and it's pretty quick and painless.
Doing this without a SQL Server on your site would be out of reach, I believe.
All the best,
Mark

 

Hi Mark

I am in the process of moving all my data from my Access database to an mdf and changing all my datasources on my site. The main reason for this is after some reading I have done, the mdf will be the best method due to the amount and frequency of users I am expecting...

Anyway, would you have any more details how I would go about updating from my local SQL server..? Or any links that may give me the steps to go through..?

Thanks (yet again!) for your help...

Cheers

Luke

 

Hi,
There are several methods to do that now, easier than ever before.
If you don't have a local copy of SQL Server 2008 you can use the Express version now.
I recommend the Developer version for this, you can get it on Amazon for under $50.
The 2008 Express version does have import/export abilities now and it can be used instead..for free.
note: You can also attend free SQL Server events around the country and get a copy of 2008 Standard for free.

Then, with any of those, you can easily make updates in any direction.
You can work with your DASP data right from your local copy.

Once I catchup I plan on creating a series of Webcasts for this very thing.
Also showing how to check for duplicate records when pumping records.
For now I have created one simple Webcast that shows how to do this with 2008:
http://www.dasptv.com/avc-view.aspx?videoid=17&categoryid=1

Hope that helps a bit.
All the best,
Mark

 

Superb. Thanks mate...!!!!