Re: [sqlite] Replicating table data from sqlite to ms sql server

2007-07-15 Thread maitong uy
versa wherein any change in sql server will be replicated in the sqlite. Sql server is managed using ASP and resides in windows server 2003. Asif Lodhi wrote: > > Hi maitong, > > On 7/11/07, maitong uy <[EMAIL PROTECTED]> wrote: >> >> >> I see...any ide

[sqlite] synchronize MS SQL server and SQLite

2007-07-12 Thread maitong uy
I have multiple devices that has an SQLite database in them. Then I have a central server , which is an MS SQL Server that manages all these devices. Is it possible to replicate the data in the MS SQL Server to the SQLite databases in the devices and vice versa? -- View this message in context:

Re: [sqlite] Replicating table data from sqlite to ms sql server

2007-07-10 Thread maitong uy
I see...any idea as to how exactly? I really am out of ideas regarding this... :( John Stanton wrote: > > Everything is possible programatically. You communicate from the Sqlite > program as you would from any application program to Sql Server. > > maitong uy wrote: >

[sqlite] RE: RE: Replicating table data from sqlite to ms sql server

2007-07-10 Thread maitong uy
ition is in the Washington D.C. metro area. If interested > contact [EMAIL PROTECTED] > > -Original Message- > From: maitong uy [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 10, 2007 8:59 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] RE: Replicating table dat

[sqlite] RE: Replicating table data from sqlite to ms sql server

2007-07-10 Thread maitong uy
The program is in C, can it write to an sql server that resides on another server? Griggs, Donald wrote: > > > Regarding: > > I'm new to sqlite and I was wondering if there is a way to > programmatically replicate table data from a database in sqlite server > to another database in ms sql

Re: [sqlite] Replicating table data from sqlite to ms sql server

2007-07-10 Thread maitong uy
wrote: > > You could register a trigger and write a user function which reads the > row you just inserted, updated or deleted and writes it to the othe DB. > The user installed Sqlite function can inherit the open database > connection as userdata. > > maito

[sqlite] Replicating table data from sqlite to ms sql server

2007-07-09 Thread maitong uy
Hello there, I'm new to sqlite and I was wondering if there is a way to programmatically replicate table data from a database in sqlite server to another database in ms sql server? I'm hoping to do this without any user intervention(the application will do it automatically). Is this possible?