With a little help from Google, I found a free tool that Microsoft makes and for my purposes, it worked ok. It is the SQL Server Migration Assistant 2005 for Access V4.0. Note that this requires you to get a "license". It's free also and I'm not sure why they do this, but so be it.
I had hoped this tool would move the data from an access table directly into a corresponding table in SQL Server. It did not do this. This is probably a simple case of user ignorance and I'm sure this tool is far more powerful than I understand. What this tool did instead is just copy the access table directly into the SQL database as a new table. Well, this certainly makes the table easier to work with if it's in the same database, so I was very happy to achieve this step, and so easily! I understand that Access has a migration tool, but I wasn't having a whole lot of luck with it.
Once the table was in my SQL database, that's when the fun began. What I did there is worthy of its own post.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment