synchronize MDB file

Hello,

I have an Access database that updates each 5 minutes with data from a weather station. As you can imagine the access database is becomming huge, so I would like to get that data into SQl Express to make queries faster and better connectivity with visual webdeveloper.

There is no way I can get the data directly into the SQL Express database, as the vendor only supplies a tool for MySQL and access through odbc.

Is there a way to sync the access database and my SQL Express each 5 minutes
And off course not manual

Thank you...

Answer this question

synchronize MDB file

EastShores

After one week of searching it looks so easy :)
Thank you for the reply.

Do you have any more info on the creation of a "Linked Server"

Thx again
robbie73
There are a couple ways you could do this:
1. Write script that grabs data from the MDB and inserts it into the SQL table. This could be a simple as a query that points to the MDB file or you could create a Linked Server to the MDB file. Then use the Windows Task Scheduler to automate the running of the script.
2. You could use SQL Service Broker to automate this as well. Service Broker is a more complex solution, but it offers the advantage handling asynch processes and it is built into the engine, so it only runs when the database is running and all the information gets backed up with the database. There is a bunch of information about Broker out there, but you can start with a white paper at http://www.microsoft.com/technet/technetmag/issues/2005/05/ServiceBroker/default.aspx.
Hope this helps.

Regards,

Mike Wachal
SQL Express team

----
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=307712&SiteID=1
Yashwant

I created a Linked server Item to the mdb file.
Now how can I run queries from within Visual WebDeveloper on that, because it is not recognised as a SQL Db.
synchronize MDB file

Answer this question