Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The fastest way to move data from one table to another?
Message
 
 
To
05/01/2009 08:42:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01370929
Message ID:
01371010
Views:
52
>>>>This seems to be very fast, very simple (as long as the two tables are identical). If not the ields that don't match will simply be ignored.
>>>
>>>Hi Garry
>>>
>>>It shuold be faster if you use scatter/gather memvar instead of scatter/gather name.
>>>But this is perhaps of more use to Naomi :)
>>>
>>
>>I was doing this, but the process didn't finish in more than 2h.
>
>I don't believe It can last that long unless something else is affecting whole thing.
>
>Did you try with copy to / append from ?

No, didn't try.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform