Question Locked

convert an Access database to a SQL server database

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

can you please tell me,

Using VB.NET how to convert an Access database to a SQL server database?

4 replies

by tony hopkinson

Get the database from access into SQL Server. DTS (Data Transfer Services) is the stand out candidate or SSIS if it's 2005.

I can't think why you would want to write your own converter. That's a lot of work re-inventing a wheel.

You could use the wizards to set up a typed dataset. And then use the type information in that to create an other one. That could go from a fair bit of work to months, dependant on how good the design fit is.

If this was a one off job I wouldn't bother writing a program to do it at all. I'd only do that if say I was converting all my customers local copy of the current schema. Even then I'd probably use the DTS runtime, or SSIS equivalent

by absolutely

Doesn't that task sound a lot more like a homework assignment than a profitable one?

by tony hopkinson

As for profitable, re-inventing wheels is most often the opposite.

This discussion is closed to new replies.