copying a database
Posted on 2003-03-24
I have a database, but the tables are views.
So I want to create a destination database which has all the records which my source database has, except that the records should not be views, but should be actual records.
I know that the logic should not be all that hard, but I don't know exactly how to PROGRAMATICALLY create a database and tables with the exact same information as in the source. Relationships are not importnant. We can assume that the destination database will have no relationships defined....
ado is prefreble, but dao is acceptable...