Wednesday, November 26, 2003
New SQL Server CE Bulk Insert Utility
Posted by Andy Sjostrom in "DEVELOPER" @ 07:00 AM
SQL Server CE is my favorite relational database in application development projects. As the system architecture most often includes a remote SQL Server, I can choose to use the "built-in" bulk insert features Remote Data Access and Merge Replication. However, in situations when a remote SQL Server is not available, inserting a large amount of data into a local SQL Server CE database can be painfully slow.
Enters Fitiri! I spotted the following post in the developer newsgroup that I'd like to extend to you!
"Since most developers active in some of the CE newsgroups have had problems with inserting data into the SQL CE, I wanted to see if you'd be willing to be a beta tester for our SQL CE Bulk Insert tool named SSCEDirect. Our initial tests for inserting 10,000 records ranged from 15 seconds to 35 seconds depending on the datatype. Our tool works with all the datatypes and unlike other loaders our tool lets you insert data from anywhere even a web service, unlike others which restrict you to Access or SQL server .... If you want more information about the tool, please go to http://www.fitiri.com/F_Wireless_Apps2.html".
Looks very promising! Has anyone already tried it out?
Enters Fitiri! I spotted the following post in the developer newsgroup that I'd like to extend to you!
"Since most developers active in some of the CE newsgroups have had problems with inserting data into the SQL CE, I wanted to see if you'd be willing to be a beta tester for our SQL CE Bulk Insert tool named SSCEDirect. Our initial tests for inserting 10,000 records ranged from 15 seconds to 35 seconds depending on the datatype. Our tool works with all the datatypes and unlike other loaders our tool lets you insert data from anywhere even a web service, unlike others which restrict you to Access or SQL server .... If you want more information about the tool, please go to http://www.fitiri.com/F_Wireless_Apps2.html".
Looks very promising! Has anyone already tried it out?
