| Groups | Blog | Home |
sql server new users : Is there something like a completely external trigger to catch updates?
We need to find out when records are added or changed in a vendor's database for a customer. The customer has said that we can't add triggers nor make other changes to their database. I've been familiar in the past with SQL databases (Oracle, Informix), but haven't been using them currently. My boss thinks that there is a way for us to write a .dll in VC++ that can somehow tell when records in a SQL-Server DB have changed. So, we're allowed to read their database, and we're allowed to install software on the same machine. But, we're not allowed to create any triggers (which could go away when their vendor provided updates). Is there some way to intercept those updates without making any changes in the SQL-Server DB itself? They currently have SQL-Server 2000, and plan on upgrading to 2005 sometime in the next year or so. At least one of the tables that I need information on does not have a datetime added/updated field, so I can't just read the table and search for new/updated records since the last time read. (Is there a better newsgroup to ask this question? It's not a new user question, but I'm certainly in the new user category.) Thank you for any direction that you can provide. -karen
There are third party tools that read the transaction log file, and log data
changes from there. If they can create the functionality, I don't see why you can't -if the skills are available. However, even the log file format can change when there is a product upgrade, so you may have to periodically upgrade your log reader also. Look for: Lumigent SQL Server log explorer ApexSQL Log Navigator Log P.I. SQL Log Rescue from red-gate -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous [quoted text, click to view] "karen" <nospambugarsnotspam@ix.netcomspamnot.com> wrote in message news:unvMKoY4GHA.3396@TK2MSFTNGP05.phx.gbl... > Hi- > We need to find out when records are added or changed in a vendor's > database for a customer. The customer has said that we can't add triggers > nor make other changes to their database. I've been familiar in the past > with SQL databases (Oracle, Informix), but haven't been using them > currently. My boss thinks that there is a way for us to write a .dll in > VC++ that can somehow tell when records in a SQL-Server DB have changed. > > So, we're allowed to read their database, and we're allowed to install > software on the same machine. But, we're not allowed to create any > triggers (which could go away when their vendor provided updates). Is > there some way to intercept those updates without making any changes in > the SQL-Server DB itself? They currently have SQL-Server 2000, and plan > on upgrading to 2005 sometime in the next year or so. > > At least one of the tables that I need information on does not have a > datetime added/updated field, so I can't just read the table and search > for new/updated records since the last time read. > > (Is there a better newsgroup to ask this question? It's not a new user > question, but I'm certainly in the new user category.) > > Thank you for any direction that you can provide. > > -karen >
Thank you, I'll look into them. Unfortunately, the skills certainly aren't
here right now. I guess that just makes it more of a challange. -karen [quoted text, click to view] "Arnie Rowland" <arnie@1568.com> wrote in message news:OWPiSsY4GHA.1196@TK2MSFTNGP02.phx.gbl... > There are third party tools that read the transaction log file, and log > data changes from there. If they can create the functionality, I don't see > why you can't -if the skills are available. However, even the log file > format can change when there is a product upgrade, so you may have to > periodically upgrade your log reader also. > > Look for: > Lumigent SQL Server log explorer > ApexSQL Log Navigator > Log P.I. > SQL Log Rescue from red-gate > > > -- > Arnie Rowland, Ph.D. > Westwood Consulting, Inc > > Most good judgment comes from experience. > Most experience comes from bad judgment. > - Anonymous > > > "karen" <nospambugarsnotspam@ix.netcomspamnot.com> wrote in message > news:unvMKoY4GHA.3396@TK2MSFTNGP05.phx.gbl... >> Hi- >> We need to find out when records are added or changed in a vendor's >> database for a customer. The customer has said that we can't add >> triggers nor make other changes to their database. I've been familiar in >> the past with SQL databases (Oracle, Informix), but haven't been using >> them currently. My boss thinks that there is a way for us to write a >> .dll in VC++ that can somehow tell when records in a SQL-Server DB have >> changed. >> >> So, we're allowed to read their database, and we're allowed to install >> software on the same machine. But, we're not allowed to create any >> triggers (which could go away when their vendor provided updates). Is >> there some way to intercept those updates without making any changes in >> the SQL-Server DB itself? They currently have SQL-Server 2000, and plan >> on upgrading to 2005 sometime in the next year or so. >> >> At least one of the tables that I need information on does not have a >> datetime added/updated field, so I can't just read the table and search >> for new/updated records since the last time read. >> >> (Is there a better newsgroup to ask this question? It's not a new user >> question, but I'm certainly in the new user category.) >> >> Thank you for any direction that you can provide. >> >> -karen >> > >
A cheaper and easier alternative would be to use the SQL Server trace
function to trace commands to a file and then periodically look through the file for changes. You should be able to limit the trace to only what you care about. -- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm [quoted text, click to view] "karen" <nospambugarsnotspam@ix.netcomspamnot.com> wrote in message news:eLip4uY4GHA.1248@TK2MSFTNGP03.phx.gbl... > Thank you, I'll look into them. Unfortunately, the skills certainly > aren't here right now. I guess that just makes it more of a challange. > > -karen > > "Arnie Rowland" <arnie@1568.com> wrote in message > news:OWPiSsY4GHA.1196@TK2MSFTNGP02.phx.gbl... >> There are third party tools that read the transaction log file, and log >> data changes from there. If they can create the functionality, I don't >> see why you can't -if the skills are available. However, even the log >> file format can change when there is a product upgrade, so you may have >> to periodically upgrade your log reader also. >> >> Look for: >> Lumigent SQL Server log explorer >> ApexSQL Log Navigator >> Log P.I. >> SQL Log Rescue from red-gate >> >> >> -- >> Arnie Rowland, Ph.D. >> Westwood Consulting, Inc >> >> Most good judgment comes from experience. >> Most experience comes from bad judgment. >> - Anonymous >> >> >> "karen" <nospambugarsnotspam@ix.netcomspamnot.com> wrote in message >> news:unvMKoY4GHA.3396@TK2MSFTNGP05.phx.gbl... >>> Hi- >>> We need to find out when records are added or changed in a vendor's >>> database for a customer. The customer has said that we can't add >>> triggers nor make other changes to their database. I've been familiar >>> in the past with SQL databases (Oracle, Informix), but haven't been >>> using them currently. My boss thinks that there is a way for us to >>> write a .dll in VC++ that can somehow tell when records in a SQL-Server >>> DB have changed. >>> >>> So, we're allowed to read their database, and we're allowed to install >>> software on the same machine. But, we're not allowed to create any >>> triggers (which could go away when their vendor provided updates). Is >>> there some way to intercept those updates without making any changes in >>> the SQL-Server DB itself? They currently have SQL-Server 2000, and plan >>> on upgrading to 2005 sometime in the next year or so. >>> >>> At least one of the tables that I need information on does not have a >>> datetime added/updated field, so I can't just read the table and search >>> for new/updated records since the last time read. >>> >>> (Is there a better newsgroup to ask this question? It's not a new user >>> question, but I'm certainly in the new user category.) >>> >>> Thank you for any direction that you can provide. >>> >>> -karen >>> >> >> > >
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |