Member Avatar for _::suhanna::_

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...

  • 4 Contributors
  • 3 Replies
  • 97 Views
  • 11 Months Discussion Span
  • Latest Post Latest Post by msuhyd1
Member Avatar for Ramy Mahrous

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.

Member Avatar for Jx_Man

wizard is great

Member Avatar for msuhyd1

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.