DATA INTEGRATION
Recreate Microsoft Access Tables in SQL Server
Here’s a tool that SQL Server has and Access doesn’t: The ability to generate SQL Scripts that can be used to recreate your table design in SQL Server -- or any other database server.
SUBSCRIBER-ONLY -- To read this article you must subscribe to DATABASED ADVISOR or DATABASED ADVISOR or MICROSOFT ACCESS ADVISOR or MICROSOFT OFFICE ADVISOR or MICROSOFT PRO DEVELOPMENT ADVISOR.
If you are a Subscriber, sign-in to view the complete article and access any Download. You can subscribe at
Advisor Store. To activate your
subscriber online access, contact
Advisor Customer Service.
Roger Carlson graduated from Western Michigan University with a BS in Computer Science and taught database design and implementation at Muskegon Community College for 12 years. His Web site has been visited by over quarter of a million visitors from 170 countries and from which an estimated three million samples have been downloaded. In January of 2006, he was awarded the Microsoft Access MVP (Most Valuable Professional) award. Roger works at Spectrum Health, the largest hospital system in out-state Michigan, as a Senior Clinical Decision Support Analyst in the Quality Improvement Department. www.rogersaccesslibrary.com
Keyword Tags: Microsoft, Microsoft Access Development, Microsoft Office Access, Microsoft SQL Server, Migration, Upsizing