I'm preparing to migrate data from an old database to a new database. The problem I'm having is that they are drastically different designs.
In the old database, objects such as Computers, Phones or Switches each have their own table and the columns of those tables are its properties.
In the new database design, all objects are in a single table and and the properties are a separate table with a relationship to the Objects table.
My initial idea was to create a set of queries that will emulate the new database and then just copy and paste the data. The problem I'm running into with that idea is that by the time I'm done building any given query I get "Query Too complex" when I open it. The old design was just too clunky. There are 36 different objects tables that I need to piece together into Union queries. The queries, I think, are too big.
If I'm on the right track with my idea and you know of a way around this problem, let me know. If my idea is way off base or if you just know of an easier way to get the job done I'd appreciate that too.
Thanks.