To complete incremental updates to our database we need to do a mixture of INSERT and UPDATE operations. timport cannot do updates, correct? If I generate a file containing SQL statements and execute this using tsql.exe can I expect it to perform well with large data sets?
Performance of timport vs tsql
Performance of timport vs tsql
Use <timport> within vortex.There you can do whatever you want with the parsed data. And you'll avoid nasty problems trying to properly escape constants to embed into sql. Vortex also has the advantage of caching the sql statements so they don't have to be reparsed for each insert/update. See <sqlcache>.
Performance of timport vs tsql
So, would a good approach be to have two data files, one containing inserts and one containing updates, or could I have a flag on each row indicating whether it is to be an insert or update?
Also, can the <timport> function read unicode files? Do I need to do anything special to insert unicode data into a table? Thanks.
Also, can the <timport> function read unicode files? Do I need to do anything special to insert unicode data into a table? Thanks.
Performance of timport vs tsql
You could use one file with a flag field telling you how to process it.
You should be able to read and insert the unicode data as long as your timport field matching expressions are correct.
You should be able to read and insert the unicode data as long as your timport field matching expressions are correct.