convert MS Access to MS SQL Server

Please support our VB.NET advertiser: Programming Forums - DaniWeb Sister Site
Reply

•
•
Join Date: Mar 2008
Posts: 24
Reputation: _::suhanna::_ is an unknown quantity at this point 
Solved Threads: 0
_::suhanna::_ _::suhanna::_ is offline Offline
Newbie Poster

convert MS Access to MS SQL Server

 
0
  #1
Mar 28th, 2008
hello...hi

im using VB.NET...can u guys teach me how to convert an Access database to a SQL server database?

i really hope u all can help me..

thank you...
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2006
Posts: 2,065
Reputation: Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice 
Solved Threads: 256
Featured Poster
Ramy Mahrous's Avatar
Ramy Mahrous Ramy Mahrous is offline Offline
Postaholic

Re: convert MS Access to MS SQL Server

 
0
  #2
Mar 28th, 2008
Create database on SQL Server, right click on it then tasks then select import data, follow the wizard...
If you want to make it programatically I guess you'll use SMO classes.
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2007
Posts: 2,641
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Solved Threads: 245
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Posting Maven

Re: convert MS Access to MS SQL Server

 
0
  #3
Mar 28th, 2008
wizard is great
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote Quick reply to this message  
•
•
Join Date: Mar 2009
Posts: 1
Reputation: msuhyd1 is an unknown quantity at this point 
Solved Threads: 0
msuhyd1 msuhyd1 is offline Offline
Newbie Poster

Re: convert MS Access to MS SQL Server

 
0
  #4
Mar 9th, 2009
Hi,


I am using Data Loader for converting data from Access to SQL Server and found it nice. Download a free copy from SNIP

Ashi
Last edited by happygeek; Aug 24th, 2009 at 3:44 pm. Reason: url snipped
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the VB.NET Forum


Views: 3140 | Replies: 3
Thread Tools Search this Thread



Tag cloud for VB.NET
"crystal .net .net2005 30minutes 2008 access application arithmetic array assignment basic binary box button buttons center code combobox component connectionstring convert cpu data database databasesearch datagrid datagridview design designer dissertation dissertations dissertationthesis dll dosconsolevb.net editvb.net error excel firewall folder highlighting image images isnumericfuntioncall listview login math memory mobile ms mssqlbackend mysql navigate net opacity pan peertopeervideostreaming picturebox picturebox1 plugin port print printing printpreview problem problemwithinstallation project record reports" reuse save savedialog serial server sorting sql storedprocedure string structures studio temp textbox timer updown upload useraccounts usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web wpf
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC