|
Home > Archive > MS Access data conversion > April 2005 > Generate SQL Script
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Generate SQL Script
|
|
|
| Hi,
I have altered the existing database in a new copy and created the missing
relationships and put some new fields. myquesiton is; Is there any way to
generate the alter/create table script from access? or how can I import the
amendments at existing live database.
Thankx..
Tausif
| |
|
| Hi,
There is no simple way of doing what you want without ether 3rd party
products, or writting code to log your database structure, showing what
has changed. I have resorted to documenting my changes in a word
document, then make the changes on the production systems out of
hours. I would love someone to correct me as I spend a lot of time
keeping my access development and production database structures in
sync.
You can use DAO/ADO to document the structure. I think only DAO will
give you indexes, but I think you will spend more time writting the
program than working on your database.
Sorry I could not answer you problem better..
Regards
Alex
|
|
|
|
|