Yes we do have a text file that has the Database schema with all the pri/foreign keys and other contrainsts.

I heard about automated ETL but never worked on any product...