David,
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.
My goal is to create VFP application which upsizes data to SQL server simply by running it by customers.
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.
>Andrus,
>
>Your first message said SQL Server, not Firebird so that's what I based my reply on. I don't have Firebird available to be able to tell you what to do there. I know that others have used it and they may be able to give you more help.
>
>If you have a lot of data to move I'd recommend you use a BCP process rather than remote views. BCP is a couple of orders of magnitude faster.
>
>>I'm planning to use Firebird SQL server and looked for upsizing into this.
>>
>>I have tried VFP upsizing wizard with PostgreSQL and Firebird servers but it gives error message.
>>
>>How to create VFP logical and date fields in remote views using Firebird SQL server ?
Andrus