Contributed by Calpont, InfiniDB Community Edition is an open source, scale-up analytics database engine for your data warehousing, business intelligence and read-intensive application needs. Enabled via MySQLTM and purpose-built for an analytical workload with column-oriented technology at its core, the multi-threaded capabilities of InfiniDB Community Edition fully encompass query, transactional support and bulk load operations.  So come on in, grab a download and get started.

             | 

How Can I Move Microsoft SQL Server Data to InfiniDB?

E-mail Print PDF

Microsoft provides Integration Services with its SQL Server product, which is a bundled data movement and BI platform.  A SQL Server DBA can use it to connect and move data to InfiniDB if they wish. 

Unlike Oracle, SQL Server does have a fast unload tool for its database called bcp.  The bcp utility can be used to create flat files of SQL Server table data that can be used to load into InfiniDB using its cpimport utility. For large volumes of data, a bcp out of SQL Server data followed by a cpimport of data into InfiniDB is likely the best strategy.