On 9 June 2010 20:44, Rich Shepard wrote:
> On Wed, 9 Jun 2010, Vivien Malerba wrote:
>
>>> I forgot to mention, the source is a PostgreSQL db, not SQLite, so
>>> there's no source file to copy. Though a backup might be
>>> interesting ...
>
>> You can use Libgda's
On Wed, 9 Jun 2010, Vivien Malerba wrote:
>> I forgot to mention, the source is a PostgreSQL db, not SQLite, so
>> there's no source file to copy. Though a backup might be
>> interesting ...
> You can use Libgda's gda-sql tool in which you can:
> * open a connection to the PostgreSQL db (for
On 9 June 2010 18:58, Scott Frankel wrote:
>
> On Jun 9, 2010, at 12:22 AM, Vivien Malerba wrote:
>
>> On 8 June 2010 22:02, Scott Frankel wrote:
>>>
>>> On Jun 8, 2010, at 12:51 PM, Jean-Christophe Deschamps wrote:
>>>
> What's the best way
rop Grumman Mission Systems
From: sqlite-users-boun...@sqlite.org on behalf of Scott Frankel
Sent: Wed 6/9/2010 11:58 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] copy data from one db to another
On Jun 9, 2010, at 12:22 AM, Vivien Malerba
On Jun 9, 2010, at 12:22 AM, Vivien Malerba wrote:
> On 8 June 2010 22:02, Scott Frankel wrote:
>>
>> On Jun 8, 2010, at 12:51 PM, Jean-Christophe Deschamps wrote:
>>
>>>
What's the best way to copy data from one db to another?
Given 2 databases with
On 8 June 2010 22:02, Scott Frankel wrote:
>
> On Jun 8, 2010, at 12:51 PM, Jean-Christophe Deschamps wrote:
>
>>
>>> What's the best way to copy data from one db to another?
>>>
>>> Given 2 databases with identical schemas, one full of data and the
>>> other empty, the
On 8 Jun 2010, at 10:47pm, Scott Frankel wrote:
> On Jun 8, 2010, at 2:28 PM, Simon Slavin wrote:
>
>> Either write a program to read record-by-record and write record-by-
>> record, or use PostgreSQL functions to write to SQL commands then
>> execute those commands to create a new SQLite
On Jun 8, 2010, at 2:28 PM, Simon Slavin wrote:
>
> On 8 Jun 2010, at 9:02pm, Scott Frankel wrote:
>
>> On Jun 8, 2010, at 12:51 PM, Jean-Christophe Deschamps wrote:
>>
What's the best way to copy data from one db to another?
Given 2 databases with identical schemas, one full of
On 8 Jun 2010, at 9:02pm, Scott Frankel wrote:
> On Jun 8, 2010, at 12:51 PM, Jean-Christophe Deschamps wrote:
>
>>> What's the best way to copy data from one db to another?
>>>
>>> Given 2 databases with identical schemas, one full of data and the
>>> other empty, the brute force way would be
The db that you open your initial connection to is called main by default. I
haven't had the occasion to use a temp or memory db so I can't comment.
The attach statement works as normal SQL.
attach 'path to your db' as 'some_alias_name'
like
attach 'c:\temp dir\db2.db' as 'db2'
Suppose both
On Jun 8, 2010, at 12:07 PM, Adam DeVita wrote:
> start by doing an open db1 (as main)
> then attach path to db2 as 'db2'
>
> insert into main.table_one_name select * from db2.table_one_name ;
>
> This selects all records from db2 and puts them into db1 in one
> statement.
I've been reading
On Jun 8, 2010, at 12:51 PM, Jean-Christophe Deschamps wrote:
>
>> What's the best way to copy data from one db to another?
>>
>> Given 2 databases with identical schemas, one full of data and the
>> other empty, the brute force way would be to perform selects on the
>> source db, then for each
>What's the best way to copy data from one db to another?
>
>Given 2 databases with identical schemas, one full of data and the
>other empty, the brute force way would be to perform selects on the
>source db, then for each row, perform an insert into the destination
>db. Is there a more
Scott Frankel wrote:
> What's the best way to copy data from one db to another?
>
> Given 2 databases with identical schemas, one full of data and the
> other empty
Why not just copy the whole file over?
--
Igor Tandetnik
___
start by doing an open db1 (as main)
then attach path to db2 as 'db2'
insert into main.table_one_name select * from db2.table_one_name ;
This selects all records from db2 and puts them into db1 in one statement.
Adam
On Tue, Jun 8, 2010 at 3:02 PM, Scott Frankel wrote:
Hi all,
What's the best way to copy data from one db to another?
Given 2 databases with identical schemas, one full of data and the
other empty, the brute force way would be to perform selects on the
source db, then for each row, perform an insert into the destination
db. Is there a more
16 matches
Mail list logo