Access to SQL

[witzulu]

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]

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]

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!

 

[Rob Mills]

I must have misunderstood. I thought you were talking about transferring the data from access to SQL server.