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

This thread is more than three months old.
Perhaps start a new thread instead?
Message:




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



Tag cloud for VB.NET
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC