Access to SQL Server converter merges data according to the following algorithm. If a table has primary key or an unique index, the program inserts into MS SQL database only those records whose key/index value does not exist in the destination table. Otherwise, the application appends the whole table contents to the corresponding SQL Server table. If the structures of source and destination tables are different, the program transforms each record of the source table so that it conforms to the destination table structure.
Have questions? Contact us