Hi Michael,
>I would have 100+ tables to replicate. Normalising the tables and eliminating the key words etc would be sweatless on the existing tables. Assuming 10 minutes per table that's about 16 hours work. Recreating the tables with different names, exporting the data & importing, well that could take three? four? times as long. Get it? Obviously using the existing tables would be a timesaver.
If I have to do that much work I do a programm (thats why I'm a programmer ::))
>Why create new tables at all? I could just rename the fields and the table name and voila! we have a "new" table! What constitutes a new table? The name? the fields? I don't know.
I depends on your needs. Sometimes there is sense in normalising, sometimes not.
I have a framework and it is with meta data so I like to press anything in that meta data, makes my life easier.
Agnes
::)
>
>
>Cheerio
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]