January 31, 2012 at 2:04 am
Hi, I'm new to sql
I have a machine which creates a new log file at the beginning of the day(12am) and updates the log file whenever there is any changes until the end of the day.
1)How do i import the data real time(30 sec, 1min or whenever there is any changes) to sql server database?
2)Will SQL server 2008 be able to access the active log file? If not will it be easier if the machine creates a new log file whenever there is any updates? But if that is the case how do i import so many log files with different names in real time. (Must be able to scale up to multiple machines)( The machine is maintained by 3rd party.)
Thx a lot
January 31, 2012 at 3:14 am
Looks like a good scenario for transactional replication.
-- Gianluca Sartori
January 31, 2012 at 3:20 am
SQL Server wont be aware of when this file is updated.
You could setup a SQL Agent job to run every minute, load the data into a staging table and then update the live table data where changed.
January 31, 2012 at 3:22 am
Alternatively, you could write a tabular function or a stored procedure to use a rowset query to access the file directly when called.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply