Is there anyway to do it? I find a msoft tool that does it for sql server 2005. There is an import feature in sql server 2008 but it doesn't do it correctly. Anyway to convert my database with all its relationships to sql server automatically??
Jump to Post
Not until you upgrade to Sql2008R2. However, if you want a quick-and-dirty, I have a little utility routine that works in Access2003 to pull out most of the table structure, keys, indexes and relationships. It isn't perfect, but it will get you a long way toward the structure.
All 3 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.