My.ADVISOR.com Sign-In
Username
Password
Sign-Up 
Go to Article
Advanced Search 

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.

 DOWNLOAD (29,020 bytes) -- Get the RecreateTableInSQLServer routine discussed in this article.
By Roger Carlson

SUBSCRIBER-ONLY -- To read this article you must have a current Subscription or Passport for DATABASED ADVISOR, and sign-in to view the complete article and access any Download. Purchase or renew your Subscription or Passport at www.AdvisorStore.com. Click this link for help with online access.

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

ADVISORAMA
Everybody is ignorant, only on different subjects.
-- Will Rogers (1879-1935)

ARTICLE INFO

DataBased Advisor

Web Edition: 2008 Week 16, Doc #19457

SUBSCRIBER ONLY ARTICLE LOCKED


 Article files are on this issue's Resource CD.
File: Get the RecreateTableInSQLServer routine discussed in this article.
DOWNLOAD: 29,020 bytes

SUBSCRIPTION STATUS
You are not signed-in. If you are a subscriber to this publication, sign-in above to access locked articles. To subscribe or renew go to www.AdvisorStore.com.

Subscribe to FileMaker Advisor Magazine

Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.

FileMaker.Advisor.com

Subscribe to Advisor Basics of FileMaker Pro

Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!

FileMaker.AdvisorBasics.com

Showcase Your Smarts

Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!

AdvisorTips.com

Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2008 Advisor Media, Inc. All Rights Reserved.
Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
Hosted by Prominic.NET Website powered by
LOTUS SOFTWARE
carlr007 posted 04/14/2008 modified 09/30/2008 03:40:12 AM ztdbms/ztdbms
domino-144.advisor.com my.advisor.com 09/30/2008 05:20:22 PM