
how to you make a duplicate database?
1. What database format: Access, DBF, SQl Server, Oracle.
There are specific methods for each database format for creation of the database unit, tables and records (including
indexes).
Access and DBF are easy - there are 3rd party components and scripts that will do the job a lot faster and better than
you could.
http://asp-database-recordset-converter-dbf-mdb-export.pstruh.cz/help...
I've got this one and it's excellent to be honest - very fast.
SQL Server and Oracle etc. (all true RDBMS systems) are a bit more difficult in that there is a lot more security and
consistency stuff going on at the database systems level to deal with. However, both at least provide documented
function and methods to create databases, tables and records - DTS, T-SQL (never used Oracle so I can't really comment).
Hope this helps.
Chris.
On a server side script I want to extract a subset of records to a new
database.
The new database should have the same structure as the original but should
only
contain records that match my criteria.
TIA.