Bulk copy from VistaDB to SQL Server Did you know you can use the SqlBulkCopy object to move data from VistaDB to SQL Server? The SqlBulkCopy object allows you to take any IDataReader object to copy. Source and Destination must match The only trick is that the source and destination tables must be setup...

Continue reading "Using SqlBulkCopy to move data from VistaDB to SQL Server"

Temp table support, and table as a variable As was sort of hinted at on the forums today, we will be adding temp table support to VistaDB 3.3. I got a number of emails from people asking if it was true (and could they test it), so I wanted to write up a brief entry about it for everyone. VistaDB 3.3...

Continue reading "VistaDB Temp Table Support"