It looks like all the DATE field are exported as TIMESTAMP by SQLite. Can we change this so it export it in regular date format?
There is only one TIMESTAMP column in a table as well in SQL Server. On Jan 12, 2013, at 1:22 PM, Ted Heng <[email protected]> wrote: Solved the BLOB issue -- Replace X' with 0X and removed the enclosing apostrophe ('). Here's another problem. I presumed the problem is with the dump value in fraction instead of in the format 'YYYYMMDD ...', etc. Can I change the date format of the dump? Operand type clash: numeric is incompatible with datetime2 CREATE TABLE ZADDRESS ( Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER, Z_OPT INTEGER, ZADDRESSID INTEGER, ZADDRESSTYPE INTEGER, ZCITY INTEGER, ZORGANIZATION INTEGER, ZPERSON INTEGER, Z23_PERSON INTEGER, ZDATECREATED DATETIME2, ZDATEUPDATED DATETIME2, ZLATITUDE REAL, ZLONGITUDE REAL, ZSTREET1 VARCHAR, ZSTREET2 VARCHAR, ZZIP VARCHAR ); INSERT INTO "ZADDRESS" VALUES(1,1,3,1,NULL,NULL,NULL,NULL,NULL,378513273.224674,378513273.224674,53.307262,-6.219077,NULL,NULL,NULL); On Jan 12, 2013, at 11:44 AM, Simon Slavin <[email protected]> wrote: On 12 Jan 2013, at 7:32pm, Ted Heng <[email protected]> wrote: > INSERT INTO "Z_METADATA" VALUES (1, '052A3800-692C-4A92-ACE8-F6CE6A3B204A', > X'62706C6973743030D601020304050607090A5556575F101E4E5353746F72654D6F64656C56657273696F6E4964656E746966696572735F101D4E5350657273697374656E63654672616D65776F726B56657273696F6E5F1019 Okay, the format X'hexdigits' is the way SQLite turns a BLOB into text. So if you can figure out the format SQL Server uses to express a BLOB as text, you can probably work out how to turn one into another using global search and replace commands in a text editor. As an alternative you could globally search and replace ', X' with ', ' which may allow SQL Server to import those values as hex. Then you can write your own code in SQL Server to turn those hex values into BLOBs. But once again: this is a SQLite list here, and if you want help with SQL Server you will have to explain SQL Server syntax to us or ask on a SQL Server list. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
