January 28, 2005 at 3:34 am
Hi guys,
I am facing a problem.I want to write a script which accepts two tablename as parameters and compare those two tables value. If any field value of a table is changed, it will show u the changed information.For this I have to write a cursor to pick up all the value.Then I have to compare row by row and then field by field.But the problem is I don't know the fields name of the table.Because the table name are not fiexed.and I cannot write select * from <tablename > in a cursor.I have to specify each field name.I can get all the fieldname from syscolumns table. but How can I execute the cursor and store that value into variables.I couldn't do that.
I don't want any site name.I don't want to any utility.How is it possible through script? Can anyone give solution.Please don't mention any site name.
write code if possible.
Can anyone help me?
Thanks & Regards
Niladri Saha
Niladri Kumar Saha
January 28, 2005 at 4:28 am
It is possible to do this, but you are really re-inventing the wheel.
Have a look on the net and you will find some very cheap tools that do this.
Have a look at Red Gate or this one http://www.sqldelta.com/.
Ther are many more around. You can search this site and find a few articles about. I have seen them over a period of time.
January 28, 2005 at 4:41 am
I don't want any site name.I don't want to any utility.How is it possible through script? Can anyone give solution.Please don't mention any site name.
write code if possible.
Thanks
Regards
Niladri Saha
Niladri Kumar Saha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply