SQLFire使用心得

1.下载SQLFire的安装包进行安装

2.新建一个数据目录，如：data，然后在bin启动：sqlf server start -dir=d:/sqlfire/data-client-port=1527 -mcast-port=16799 -bind-address=192.168.1.66

3.对于连接SQLFire可以使用 SQLFire\vFabric_SQLFire_102\bin\sqlf，也可以使用Squirrel(需要使用sqlfireclient.jar)进行连接

4.登录后新建一个数据库表，脚本如下：

CREATE TABLE dbo.TestEmployee
(
   ID int,
   NAME varchar(10),
   OK char(1) for bit data,
   BIRTHDAY date,
   BIRTHDAY2 time,
   BIRTHDAY3 timestamp
)

 

5.引用 VMware.Data.SQLFire, sqlfireclient,

class Example
{
 public static void Test()
 {

  string sqlfHost = "mymachinename";
  int sqlfPort = 1527;
  string connectionStr = string.Format(@"server={0}:{1}", sqlfHost, sqlfPort);

  using (SQLFClientConnection conn = new SQLFClientConnection(connectionStr))
  {
   conn.Open();

   SQLFCommand cmd = conn.CreateCommand();
   cmd.CommandType = CommandType.Text;
   cmd.CommandText = "insert into dbo.TestEmployee(id, name, ok, birthday, birthday2, birthday3) values(:Id, :Name, :ok, :birthday, :birthday2, :birthday3)";
   cmd.Prepare();

   for (int i = 1; i < 10; i++)
   {
    cmd.Parameters.Add("Id", SQLFType.Integer, i.ToString());
    cmd.Parameters.Add("Name", SQLFType.VarChar, "abc1234");
    cmd.Parameters.Add("ok", SQLFType.Binary, new byte[] { 1 });
    cmd.Parameters.Add("birthday", SQLFType.Date, DateTime.Now);
    cmd.Parameters.Add("birthday2", SQLFType.Time, DateTime.Now.AddYears(10));
    cmd.Parameters.Add("birthday3", SQLFType.TimeStamp, DateTime.Now.AddYears(1));

    cmd.AddBatch();
   }
   cmd.ExecuteBatch();

  }
 }
}

6.导入导出：

CALL SYSCS_UTIL.EXPORT_TABLE('dbo','table1','d:\\myfile.del',null,null,null);
CALL SYSCS_UTIL.EXPORT_QUERY('select * from dbo.table1','d:\\myfile2.del',null,null,null);

call syscs_util.Import_Data('APP', 'table1', 'Id,Name', null, 'd:\\sqlfireimport2.txt', null, null, null, 0)

call SYSCS_UTIL.IMPORT_TABLE('app', 'table1', 'd:\\sqlfireimport2.txt', ',', NULL, NULL, 1);

 

对于identity列如果要导入的话要用by default，或者在导入时跳过这一列：

 CALL SYSCS_UTIL.IMPORT_DATA (NULL, 'table1', 'c1,c3,c4' , '1,3,4', 'd:\\a.txt',null, null,null,0)

 

 

另外还可以试下GemFire, MemSQL