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

2007-07-17 Thread Asif Lodhi
Hi maitong, On 7/16/07, maitong uy <[EMAIL PROTECTED]> wrote: The scenario would be the sqlite database is managed using CGI C, resides in Linux environment, and accessed through the web. Then the sql server would be replicating whatever changes would occur in the sqlite database (both sqlite an

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

2007-07-15 Thread maitong uy
The scenario would be the sqlite database is managed using CGI C, resides in Linux environment, and accessed through the web. Then the sql server would be replicating whatever changes would occur in the sqlite database (both sqlite and sql server have the same tables). This will also happen vice v

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

2007-07-14 Thread Asif Lodhi
Hi maitong, On 7/11/07, maitong uy <[EMAIL PROTECTED]> wrote: I see...any idea as to how exactly? I really am out of ideas regarding this... :( I think I did see some UnixODBC files on a Linux environment (Fedora Core 6, to be exact) and if you have the same kind of UnixODBC files on your s

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

2007-07-14 Thread John Stanton
You can write a program which uses the Sqlite API to read the Sqlite database and the Sql Server API to write to Sql Server. maitong uy wrote: I see...any idea as to how exactly? I really am out of ideas regarding this... :( John Stanton wrote: Everything is possible programatically. You co

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: >> The sqlite runs in a L

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

2007-07-10 Thread John Stanton
Everything is possible programatically. You communicate from the Sqlite program as you would from any application program to Sql Server. maitong uy wrote: The sqlite runs in a Linux environment and can be accessed through a web server. The ms sql server resides in a windows environment and has

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

2007-07-10 Thread maitong uy
The sqlite runs in a Linux environment and can be accessed through a web server. The ms sql server resides in a windows environment and has its own web server. Can this still be possible? It's more of like having a server to server communication. Is this programmatically possible? John Stanton w

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

2007-07-10 Thread John Stanton
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. maitong uy wrote: Hello there, I'm new to sqlite and I was

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

2007-07-10 Thread Griggs, Donald
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 server? I'm hoping to do this without any user intervention(the application will do it automatically). Is this possible? -