I have a general question. I'm using ETL s/w to move data between source db and a datawarehouse; you select the tables+fields you want from the source and it builds records for you in the datawarehouse (which for my purpose is a MySQL db). Interestingly the ETL system doesn't need any information about the source db (which is in SQL Server 2005) and in this particular db there are no pre-existing relationships defined in this db. Essentially it builds an INSERT ... SELECT query on its own. Is there some SQL Server trick -- or general relational db trick -- that allows the ETL s/w to build this query without knowing what the relationships are in the source (i.e.,SQL Server) db? As I said there are no existing relationships in the SQL Server db. Because the naming conventions used were rather odd, FK names don't match PKs. Thanks!