convert an Access database to a SQL server database
can you please tell me,
Using VB.NET how to convert an Access database to a SQL server database?
Networks
can you please tell me,
Using VB.NET how to convert an Access database to a SQL server database?
by shinde.shital Accepted solution
by tony hopkinson Accepted solution
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 Accepted solution
by tony hopkinson Accepted solution
This discussion is closed to new replies.
Sort by Trending