Submit Your Article Webforumz RegistrationAnnouncements Contact Webforumz StaffContact
Home Resources Blogs Meet the Team Contact Register
 

Go Back   WebForumz.com > Putting it Together > Databases
Reload this Page converting msaccess > sql
Register All Albums Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

Closed Thread
 
LinkBack Thread Tools
Old September 29th, 2004, 06:36 AM   #1
Most Reputable Member
 
spinal007's Avatar
 

Join Date: Mar 2004
Location: Good Ol'London
Age: 24
Posts: 1,684
Blog Entries: 1
Thanks: 1
Thanked 4 Times in 4 Posts
Rep Altering Power: 0 spinal007 has a spectacular aura about spinal007 has a spectacular aura about
converting msaccess > sql
are there any key things I should know?
can I keep the database desgin/data/relationships?
any easy-to-use programs out there?
spinal007 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Old September 29th, 2004, 06:44 AM   #2
Rob
Elite Veteran
SuperMember
 
Rob's Avatar
 

Join Date: Jul 2003
Location: Southern UK
Age: 35
Posts: 3,126
Blog Entries: 7
Thanks: 28
Thanked 22 Times in 19 Posts
Rep Altering Power: 0 Rob is a jewel in the rough Rob is a jewel in the rough Rob is a jewel in the rough
Hi Spinal...

You will find that MS Access has an 'upsizing' wizard (menu: tools > database utilities).

This should basically walk you through the process of switching to SQL from access.

As far as I am aware, relationships are preserved (if you have defined them)

Post back here if you get stuck or need further info.
__________________
Rob - Webforumz Founder
Web Designer Support Network || Personal Project: Sanctuary for Student Midwives
Rob is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Old September 29th, 2004, 08:04 AM   #3
Highly Reputable Member
 

Join Date: Jul 2003
Location: Ipswich, UK
Posts: 686
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Altering Power: 0 Smokie will become famous soon enough
Yes the upsizing wizard will convert everything for you. You should also note that you may need to change some of your SQL queries, date handling in SQL Server is different.
Smokie is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Old September 29th, 2004, 01:22 PM   #4
Most Reputable Member
 
spinal007's Avatar
 

Join Date: Mar 2004
Location: Good Ol'London
Age: 24
Posts: 1,684
Blog Entries: 1
Thanks: 1
Thanked 4 Times in 4 Posts
Rep Altering Power: 0 spinal007 has a spectacular aura about spinal007 has a spectacular aura about
thanks guys!
spinal007 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Closed Thread

Bookmarks

Tags
converting , msaccess , sql

« RANK / Position | Google's "Did you mean" feature »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting this to css..... jahphill HTML, XHTML and CSS 3 June 9th, 2008 07:19 AM
converting an swf into an fla danny322 Flash and ActionScript 5 February 2nd, 2008 04:32 AM
converting to css sliz HTML, XHTML and CSS 5 August 28th, 2007 10:30 AM
MSAccess query error contiw Databases 1 September 15th, 2005 07:09 PM
ASP & MSAccess joshlindem Classic ASP 1 July 19th, 2005 03:43 AM

WebForumz.com is an iEntry Network® publication - 1998-2009 All Rights Reserved Privacy Policy and Legal
Contact Us - Web Design and Web Development forums for Beginners to Advanced - Archive - Top

Search Engine Optimization by vBSEO 3.2.0 RC8