Re: [sqlite] intial database creation

2012-05-11 Thread Black, Michael (IS)
ics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of McSparin, Brett E [brett.e.mcspa...@boeing.com] Sent: Thursday, May 10, 2012 3:26 PM To: sqlite-users@sqlite.org Sub

Re: [sqlite] intial database creation

2012-05-10 Thread Teg
Hello Brett, All of my DB's are generated in code. When I version control the code, I'm also version controlling the schema. If my users end up with bad DB's (it's windows, it happens fairly frequently). They just delete them and they're then re-created as needed by the program. I have specific

Re: [sqlite] intial database creation

2012-05-10 Thread Mircea Neacsu
Same basic advice as Michael. If I may add however, you make a separate SQL file with just the database schema and put it under version control same way you would do with any other source file. Other test cases and sample queries can also be version controlled but would probably be separate fr

Re: [sqlite] intial database creation

2012-05-10 Thread Black, Michael (IS)
E [brett.e.mcspa...@boeing.com] Sent: Thursday, May 10, 2012 3:26 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] intial database creation How does one go about creating a database initially in SQLite? Do you create a schema file for it to read or similar?

[sqlite] intial database creation

2012-05-10 Thread McSparin, Brett E
How does one go about creating a database initially in SQLite? Do you create a schema file for it to read or similar? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users