Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

On 13 Jan 2013, at 1:38am, Ted Heng wrote: > Thanks for all the help. I was able to get my SQLite database imported from > the dump file after correcting several issues with the exported SQL > statements like VARCHAR with no length and a few other stuff. The fact that >

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

Hi Simon, Thanks for all the help. I was able to get my SQLite database imported from the dump file after correcting several issues with the exported SQL statements like VARCHAR with no length and a few other stuff. The fact that I have to use REAL for DATETIME field will be an issue, but

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

On 12 Jan 2013, at 9:22pm, Ted Heng wrote: > Here's another problem. I presumed the problem is with the dump value in > fraction instead of in the format 'MMDD ...', etc. Can I change the date > format of the dump? SQLite doesn't have a date format. You can choose

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

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 wrote: Solved the BLOB issue --

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

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 'MMDD ...', etc. Can I change the date format of the dump? Operand type clash: numeric is

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

On 12 Jan 2013, at 7:32pm, Ted Heng wrote: > INSERT INTO "Z_METADATA" VALUES (1, '052A3800-692C-4A92-ACE8-F6CE6A3B204A', >

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

Here's one problem. I got the exported SQL statements and Microsoft SQL Server Management Studio complains about this statement. Here's the exact error message. Msg 102, Level 15, State 1, Line 45568 Incorrect syntax near

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

On 12 Jan 2013, at 7:13pm, Ted Heng wrote: > There are some compatibilities with SQL statements between SQLite and SQL > Server like X' for blob etc. The syntax produced by the SQLite shell tool is fairly conservative, attempting to be compatible with other SQL engines.

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

There are some compatibilities with SQL statements between SQLite and SQL Server like X' for blob etc. Do we have a list of known compatibility issue that I can use to change the dump statements to the proper SQL Server syntax? Thanks, Simon. On Jan 12, 2013, at 11:01 AM, Simon Slavin

Re: [sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

On 12 Jan 2013, at 6:58pm, Ted Heng wrote: > I'm trying to export my SQLite database into SQL Server 2008, but it's very > difficult. I'm building an iOS App using Core Data with SQLite and it works > very well. Use a SQLite tool to dump to .csv or SQL format, then use a

[sqlite] Best Tool for Exporting SQLite Database into SQL Server 2008

Hi, I'm trying to export my SQLite database into SQL Server 2008, but it's very difficult. I'm building an iOS App using Core Data with SQLite and it works very well. However, I need to synchronize it with my ASP.NET website. I really don't seem to find a good approach to accomplish this