Andrus,
>Sorry.
>I used the "SQL server" as general term. In my knowledge, there is no product which name is simply "SQL Server". There is always some name added before those words.
I'd say the other way, I think "SQL Server" to most people here means some version of Microsoft SQL Server. Usually other backends are called out by name: Oracle, Sybase, MySQL, Firebird, etc.
>My goal is to create VFP application which upsizes data to SQL server simply by running it by customers.
That's a not so trivial feat to accomplish. I'm sure there are enough idiosyncratic differences beween each backend that you'd have a fair amount of CASEing in your code. Good luck with it.
>Some of my customers have running SQL servers in a server computers where I sysadmins doesnt allow to run my application directly. Also, some SQL servers are running in environments where VFP is not capable to run.
>
>So i cannot use bulk copy.
>I think I must create VFP application which runs the whole night and upsizes
>all data to a SQL server and runs command like PostgreSQL VACUUM after that. Upsizing which takes 6 hours is acceptable for me.