Packaging/Distributing a Database
I have a web-based application ( http://www.***.com/ ) that uses a SQL or
Access database. Currently I distribute the Access DB in 2000 and 97
formats....no problem here. When my initial database was small, I just
created a script for query analyzer to create the database in SQL. That was
working fine, but now I have about 1000 records that I want to include in
the initial database. What is the recommended way to do distribute a
database like this? Whatever way I choose needs to be compatible with SQL
6.5, 7.0 and 2000. I kept the database fairly simple so it can easily be
ported to other systems (Oracle, MySQL, etc).
FYI, those 1000 records that need to be inserted already are in a text file.
Maybe I could create a batch file and bulk copy them in? The file format I
am using is:
; comment
; another comment
[section header that can be ignored]
somevariable=some text
anothervar=more text
Thanks!
Doug
