[sqlite] Unicode Character

Hi All, We have a field of datatype nvarchar in SQL Server 2005, which stores the data in unicode. When I export the data into SQLite, it is storing as ascii, even if I change the datatype as nvarchar when the table is created. I am using SQL Maestro tool to export the data from SQL Serve

Re: [sqlite] SQLite Import Tool

ication and source:> > http://www.proghack.net/?p=40> > On Wed, Nov 12, 2008 at 3:20 PM, Baskaran Selvaraj <> [EMAIL PROTECTED]> wrote:> > >> > Thanks roosevelt. I will try to use the c# command.> >> > > Date: Wed, 12 Nov 2008 15:03:41 -0500&g

Re: [sqlite] SQLite Import Tool

t; accomplish what you need. If you want the app, I could > send it to you.> > On Wed, Nov 12, 2008 at 9:45 AM, Baskaran Selvaraj> > <[EMAIL PROTECTED]> wrote:> >> >> > Hi All,> > This is Baskaran and I am > looking for a vendor tool to automate the

Re: [sqlite] SQLite Import Tool

Hi Donald, 1. Size of the SQLite Database : 43 MB. 2. Number of tables : 45 3. Maximum number of rows in a table is around 75,000 We initially tried with few tables and it was not always successful but after we got to 45 tables, we did not use SQLite ODBC driver at all. Rght now, I am u

Re: [sqlite] SQLite Import Tool

use SQLite ODBC Driver and SQL Management Studio Data Transfer> > Wizard to perform this action.> > On Wed, Nov 12, 2008 at 12:45 PM, Baskaran > Selvaraj <> [EMAIL PROTECTED]> wrote:> > >> >> > Hi All,> > This is Baskaran > and I am looking for a

Re: [sqlite] SQLite Import Tool

can > probably do it with the two systems' command line tools> (generate a text > file with one and read it with the other). DTS/SSIS> will probably do the > trick for you too.> > In short: don't over-complicate things. :)> > -T> > On > Wed, No

[sqlite] SQLite Import Tool

automate the process of importing the data from SQL Server 2005 to SQLite database on a daily basis . Thanks Baskaran Selvaraj, DBA _ See how Windows® connects the people, information, and fun that are part of your life http