Packaging/Distributing a Database 
Author Message
 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



Sat, 22 May 2004 05:53:04 GMT
 Packaging/Distributing a Database

doug,

create script(s) to create appropriate schema (i.e. db, table, sproc, etc).
leave the data as text files and create another set of script(s) to import
the data.

with just these scripts/text files you can easily shrink them down real
small with winzip.

-oj


Quote:
> I have a web-based application (http://www.liberum.org) 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



Sat, 22 May 2004 12:59:26 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Version Controlling, Configuration Management, Packaging distributing and Installing SP's

2. Distributing a DTS structured file package

3. Distributing DTS Package

4. Question about distributing (or Not) the mdac_typ package ..

5. Licence issues when distributing dts packages in VB app

6. Locating a DB2 package for distributed applications

7. package deployment not distributing ADO properly

8. Fail to open distributed transaction on DTS package.

9. Distributing DTS packages with custom application

10. Distribute DTS package

11. Distributed DTS Packages

12. distributed query,distributed transaction,sp_getapplock


 
Powered by phpBB® Forum Software