Access to SQL

witzulu

Member
Joined
Jul 3, 2004
Messages
20
Programming Experience
3-5
Hi I have written a new program in vb.net but now need to "upgrade" the data from their old system to the new one I developed. The old system used a simple Access database but heve been in use for years. My new system relies on SQL.

Does Anyone have any ideas on how this can be done. Or where I can go to gain more information.
 

Rob Mills

Member
Joined
Jun 9, 2004
Messages
6
Programming Experience
Beginner
I know you can create a link to the SQL server in the access database. From there I would use queries to copy the data over to the server.
 

suddenelfilio

Well-known member
Joined
Jun 3, 2004
Messages
144
Location
Belgium
Programming Experience
5-10
The solutions above is a ljust a bit too much overhead you may want from an application.
since you were working with an access database everything ADO.NEt related should be from the OleDB namespace. Try replacing these objects with the corresponding objects from the Sqlclient namespace and don't forget to adjust the connectionstring to the SQL server!
 
Top Bottom