October 31, 2001 at 8:12 am
Hey there,
We have converted a couple of access databases which our client was using to track customer data (100 fields) into SQL Server 7 datasource and provided them a web interface to the data. The current datasource is well-formed and normalized and the access DBs were not. Now several months later, someone forgot to tell an admin assistant that she should use the Web interface and has been making changes and additions to the Access files. The client would like us to scrub the access data and get it into the SQL server datasource. There is no timestamp data associated with the access records.
What would be the best approach to get this data into our new model without manually comparing every record (about 1700)? IS there are way to write a script to compare records and only move across the data which has changed.
Sorry if this is a newbie question, but haven't really com across this before.
Thanks,
Kit
October 31, 2001 at 9:24 am
I just put up a review of a product called Data Compare, might be worth looking at for this problem. It does a field by field compare, with a few limitations.
http://www.sqlservercentral.com/columnists/awarren/reviewofdatacomparev151.asp
Andy
October 31, 2001 at 10:31 am
The other alternative is to import the data into SQL Server into a second table. Then
update the first table from the second table where rows match.
delete the matching rows from the second table
insert all remaining rows into the first table.
I would recommend, however, if you can, to use RedGates product. It will make this much easier.
Steve Jones
October 31, 2001 at 10:38 am
I agree with Steve, I download the bundle sw, from RedGates and it is quit intresting, I am starting to use it. It is fine.
Have a great day, I hope I could help
Ana
Ana
October 31, 2001 at 12:27 pm
Thanks, all. I will give it a try
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply