You'll need to know something about your data. You'll need the midpoint of each table so or at least something close.
Then create two db's attach the original. And insert the data using a select statement with a where clause. --- On Thu, 3/12/09, baxy77bax <b...@hi.htnet.hr> wrote: > From: baxy77bax <b...@hi.htnet.hr> > Subject: Re: [sqlite] how to divide a database? > To: sqlite-users@sqlite.org > Date: Thursday, March 12, 2009, 4:13 PM > ok, i have one database with two tables and i want to create > two databases , > each with two tables in which contain half of the initial > data > > input: > > db > table1 table2 > aaaa 11 > bbbb 22 > cccc 33 > dddd 44 > > > result: > > db1 db2 > table1 table2 table1 table2 > aaaa 11 cccc 33 > bbbb 22 dddd 44 > > > Jim Dodgen wrote: > > > > I am confused also. > > > > Are you wanting to put half the rows from each table > in each database? > > > > On Thu, Mar 12, 2009 at 2:01 PM, baxy77bax > <b...@hi.htnet.hr> wrote: > >> > >> hi, > >> let say that i have one db with 2 tables in it. > and now i wish to divide > >> that database in 2 equal (half size of the > original) databases. two > >> tables > >> in initial database have one column. how would i > do that ?:confused: > >> any suggestions > >> > >> thank you > >> -- > >> View this message in context: > >> > http://www.nabble.com/how-to-divide-a-database--tp22485238p22485238.html > >> Sent from the SQLite mailing list archive at > Nabble.com. > >> > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > > > > > > > -- > > Jim Dodgen > > j...@dodgen.us > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > View this message in context: > http://www.nabble.com/how-to-divide-a-database--tp22485238p22485445.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users