ETL

Using Microsoft Access for ETL

Challenge: Taking information out of MS SQL Server database and putting it into MySQL database – de-normalized for reporting (without spending a fortune). Tentative Solution: Use Microsoft Access to bridge the divide with linked tables, pass-through queries, and append queries. Create a simple “make-table” query in MS Access to query SQL Server and make a local table. This query will later be changed to an “update-table” query. Hint: add a constraint (or add a “top x”) to limit your data – you []