blocks|key|1731001|text|SQLite有一个可以在命令行运行的.dump选项。尽管我更喜欢使用SQLite+Database+Browser应用程序来管理SQLite数据库。您可以将结构和内容导出到几乎任何人都可以读取的.sql文件。文件>导出>数据库到SQL文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1731002|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/SQLite|1|http://sqlitebrowser.sourceforge.net/^0|0|6|0|Y|N|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

<a href="http://en.wikipedia.org/wiki/SQLite" rel="noreferrer">SQLite</a> does have a .dump option to run at the command line. Though I prefer to use the <a href="http://sqlitebrowser.sourceforge.net/" rel="noreferrer">SQLite Database Browser</a> application for managing SQLite databases. You can export the structure and contents to a .sql file that can be read by just about anything. File > Export > Database to SQL file.

blocks|key|1731090|text|SQLite+.dump命令将数据库的全部内容输出为ASCII码文本文件。此文件为标准SQL格式，因此可以导入到任何SQL数据库中。更多详细信息请访问此页面：sqlite3|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1731091|entityMap|0|LINK|mutability|MUTABLE|url|http://sqlite.org/sqlite.html^0|7|5|27|7|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

The SQLite <code>.dump</code> command will output the entire contents of the database as an ASCII text file. This file is in standard SQL format, so it can be imported into any SQL database.
More details on this page: <a href="http://sqlite.org/sqlite.html" rel="noreferrer">sqlite3</a>

blocks|key|1516057|text|一个想法是这样做：-在sql+lite中查看squema并获取CREATE+TABLE命令。-在sql+SERVER中执行，解析SQL+-旅行数据为每行创建一个INSERT语句。(也解析sql+)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1516058|这段代码是测试版的，因为没有检测到类型数据，也没有使用@参数和命令对象，而是运行。|1516059|(需要插入引用并安装System.Data.SQLite;)|1516060|c#：在head+cs中插入此代码(或neccesari)|1516061|使用系统；|1516062|使用System.Collections.Generic；|1516063|使用System.Text；|1516064|使用System.Data；|1516065|使用System.Data.SqlClient；|1516066|使用System.Data.SQLite；|1516067|使用System.Threading；|1516068|使用System.Text.RegularExpressions；|1516069|使用System.IO；|1516070|使用log4net；|1516071|使用System.Net；|1516072|++++public+static+Boolean+SqLite2SqlServer(string+sqlitePath,+string+connStringSqlServer)
++++{
++++++++String+SqlInsert;
++++++++int+i;
++++++++try
++++++++{

++++++++++++string+sql+=+"select+*+from+sqlite_master+where+type+=+'table'+and+name+like+'YouTable+in+SQL'";
++++++++++++string+password+=+null;
++++++++++++string+sql2run;
++++++++++++string+tabla;
++++++++++++string+sqliteConnString+=+CreateSQLiteConnectionString(sqlitePath,+password);
++++++++++++//sqliteConnString+=+"data+source=C:\\pro\\testconverter\\Origen\\FACTUNETWEB.DB;page+size=4096;useutf16encoding=True";

++++++++++++using+(SQLiteConnection+sqconn+=+new+SQLiteConnection(sqliteConnString))
++++++++++++{



++++++++++++++++sqconn.Open();

++++++++++++++++SQLiteCommand+command+=+new+SQLiteCommand(sql,+sqconn);
++++++++++++++++SQLiteDataReader+reader+=+command.ExecuteReader();

++++++++++++++++SqlConnection+conn+=+new+SqlConnection(connStringSqlServer);
++++++++++++++++conn.Open();
++++++++++++++++while+(reader.Read())
++++++++++++++++{
++++++++++++++++++++//Console.WriteLine("Name:+"+%2B+reader["name"]+%2B+"\tScore:+"+%2B+reader["score"]);
++++++++++++++++++++sql2run+=+""+%2B+reader["sql"];
++++++++++++++++++++tabla+=+""+%2B+reader["name"];

++++++++++++++++++++/*
++++++++++++++++++++sql2run+=+"Drop+table+"+%2B+tabla;
++++++++++++++++++++SqlCommand+cmd+=+new+SqlCommand(sql2run,+conn);+++++++++++++++++++++++
++++++++++++++++++++cmd.ExecuteNonQuery();
++++++++++++++++++++*/



++++++++++++++++++++sql2run+=+sql2run.Replace("COLLATE+NOCASE",+"");
++++++++++++++++++++sql2run+=+sql2run.Replace("+NUM",+"+TEXT");
++++++++++++++++++++SqlCommand+cmd2+=+new+SqlCommand(sql2run,+conn);
++++++++++++++++++++cmd2.ExecuteNonQuery();


++++++++++++++++++++//+insertar+los+datos.
++++++++++++++++++++string+sqlCmd+=+"Select+*++From+"+%2B+tabla;
++++++++++++++++++++SQLiteCommand+cmd+=+new+SQLiteCommand(sqlCmd,+sqconn);
++++++++++++++++++++SQLiteDataReader+rs+=+cmd.ExecuteReader();
++++++++++++++++++++String+valor+=+"";
++++++++++++++++++++String+Valores+=+"";
++++++++++++++++++++String+Campos+=+"";
++++++++++++++++++++String+Campo+=+"";
++++++++++++++++++++while+(rs.Read())
++++++++++++++++++++{
++++++++++++++++++++++++SqlInsert+=+"INSERT+INTO+"+%2B+tabla;
++++++++++++++++++++++++Campos+=+"";
++++++++++++++++++++++++Valores+=+"";
++++++++++++++++++++++++for+(+i+=+0;+i+<+rs.FieldCount+;+i%2B%2B)
++++++++++++++++++++++++{

++++++++++++++++++++++++++++//valor+=+""+%2B+rs.GetString(i);
++++++++++++++++++++++++++++//valor+=+""+%2B+rs.GetName(i);
++++++++++++++++++++++++++++Campo+=+""+%2B+rs.GetName(i);
++++++++++++++++++++++++++++valor+=+""+%2B+rs.GetValue(i);

++++++++++++++++++++++++++++if+(Valores+!=+"")
++++++++++++++++++++++++++++{
++++++++++++++++++++++++++++++++Valores+=+Valores+%2B+',';
++++++++++++++++++++++++++++++++Campos+=+Campos+%2B+',';
++++++++++++++++++++++++++++}
++++++++++++++++++++++++++++Valores+=+Valores+%2B+"'"+%2B+valor+%2B+"'";
++++++++++++++++++++++++++++Campos+=+Campos+%2B+Campo;
++++++++++++++++++++++++}
++++++++++++++++++++++++SqlInsert+=+SqlInsert+%2B+"("+%2B+Campos+%2B+")+Values+("+%2B+Valores+%2B+")";
++++++++++++++++++++++++SqlCommand+cmdInsert+=+new+SqlCommand(SqlInsert,+conn);
++++++++++++++++++++++++cmdInsert.ExecuteNonQuery();


++++++++++++++++++++}


++++++++++++++++}

++++++++++++++++}
++++++++++++return+true;
++++++++}+//END+TRY
++++++++catch+(Exception+ex)
++++++++{
++++++++++++_log.Error("unexpected+exception",+ex);

++++++++++++throw;

++++++++}+//+catch
++++}|code-block|syntax|javascript|1516073|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1C|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1D|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1E|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1F|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1G|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1H|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1I|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1J|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1K|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1L|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1M|8|@]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1N|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|1O|8|@]|9|@]|A|$]]|$1|13|3|14|5|15|7|1P|8|@]|9|@]|A|$16|17]]|$1|18|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|19|$]]

A idea is do some thing like this:
- View squema in sql lite and get the CREATE TABLE command.
- Execute, parsing sql, in SQL SERVER
- Travel data creating a INSERT statment for each row. (parsing sql too)

This code is beta, because no detect type data, and no use @parameter and command object, but run.

(You need insert reference and install System.Data.SQLite;)

c#:
Insert this code (or neccesari) in head cs

using System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Data.SqlClient;

using System.Data.SQLite;

using System.Threading;

using System.Text.RegularExpressions;

using System.IO;

using log4net;

using System.Net;

<pre><code> public static Boolean SqLite2SqlServer(string sqlitePath, string connStringSqlServer)
 {
 String SqlInsert;
 int i;
 try
 {

 string sql = "select * from sqlite_master where type = 'table' and name like 'YouTable in SQL'";
 string password = null;
 string sql2run;
 string tabla;
 string sqliteConnString = CreateSQLiteConnectionString(sqlitePath, password);
 //sqliteConnString = "data source=C:\\pro\\testconverter\\Origen\\FACTUNETWEB.DB;page size=4096;useutf16encoding=True";

 using (SQLiteConnection sqconn = new SQLiteConnection(sqliteConnString))
 {



 sqconn.Open();

 SQLiteCommand command = new SQLiteCommand(sql, sqconn);
 SQLiteDataReader reader = command.ExecuteReader();

 SqlConnection conn = new SqlConnection(connStringSqlServer);
 conn.Open();
 while (reader.Read())
 {
 //Console.WriteLine("Name: " + reader["name"] + "\tScore: " + reader["score"]);
 sql2run = "" + reader["sql"];
 tabla = "" + reader["name"];

 /*
 sql2run = "Drop table " + tabla;
 SqlCommand cmd = new SqlCommand(sql2run, conn); 
 cmd.ExecuteNonQuery();
 */



 sql2run = sql2run.Replace("COLLATE NOCASE", "");
 sql2run = sql2run.Replace(" NUM", " TEXT");
 SqlCommand cmd2 = new SqlCommand(sql2run, conn);
 cmd2.ExecuteNonQuery();


 // insertar los datos.
 string sqlCmd = "Select * From " + tabla;
 SQLiteCommand cmd = new SQLiteCommand(sqlCmd, sqconn);
 SQLiteDataReader rs = cmd.ExecuteReader();
 String valor = "";
 String Valores = "";
 String Campos = "";
 String Campo = "";
 while (rs.Read())
 {
 SqlInsert = "INSERT INTO " + tabla;
 Campos = "";
 Valores = "";
 for ( i = 0; i &lt; rs.FieldCount ; i++)
 {

 //valor = "" + rs.GetString(i);
 //valor = "" + rs.GetName(i);
 Campo = "" + rs.GetName(i);
 valor = "" + rs.GetValue(i);

 if (Valores != "")
 {
 Valores = Valores + ',';
 Campos = Campos + ',';
 }
 Valores = Valores + "'" + valor + "'";
 Campos = Campos + Campo;
 }
 SqlInsert = SqlInsert + "(" + Campos + ") Values (" + Valores + ")";
 SqlCommand cmdInsert = new SqlCommand(SqlInsert, conn);
 cmdInsert.ExecuteNonQuery();


 }


 }

 }
 return true;
 } //END TRY
 catch (Exception ex)
 {
 _log.Error("unexpected exception", ex);

 throw;

 } // catch
 }
</code></pre>

blocks|key|1731211|text|适用于Android。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1731212|adb+root
adb+shell
cd+/data/com.xxx.package/databases/
sqlite3+db_name+.dump+>dump.sql|code-block|syntax|javascript|1731213|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For Android.

<pre><code>adb root
adb shell
cd /data/com.xxx.package/databases/
sqlite3 db_name .dump &gt;dump.sql
</code></pre>

Is there a tool to migrate an <a href="http://en.wikipedia.org/wiki/SQLite" rel="noreferrer">SQLite</a> database to <a href="http://en.wikipedia.org/wiki/Microsoft_SQL_Server" rel="noreferrer">SQL Server</a> (both the structure and data)?

问从SQLite导出到SQL Server
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从SQLite导出到SQL ServerEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从SQLite导出到SQL Server
EN