Convert Access data base to SQL Server

Question

I've created an application using ASP.NET with Access DB, now I found somee.com who support only SQL Server DBs, so Now I must convert my Access DB to SQL Server DB.

Is there any tool who can do the trick ?

This is some code I'm using in my web application :

Public Shared Function conecter() As OleDbConnection
Dim MyConnexion As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & System.AppDomain.CurrentDomain.BaseDirectory & "/Learning.mdb")
MyConnexion.Open()
Return MyConnexion
End Function

Public Shared Function lecture(ByVal requete As String) As OleDbDataReader
Dim Mycommand As OleDbCommand = conecter().CreateCommand()
Mycommand.CommandText = requete
Dim myReader As OleDbDataReader = Mycommand.ExecuteReader()
Return myReader
End Function

In this case, If I convert my database I must change the OleDbConnexion and other things or I can just leave them like that ?

in addition to all the answers here, try doing some validity checks on any data in your DateTime fields, if any. That's a big cause of migration problems. — Patrick Honorez
– Patrick Honorez, Commented Dec 4, 2010 at 13:10

Bob Palmer · Accepted Answer · 2010-12-03 17:37:43Z

4

Your connection string will need to change. Connectionstrings.com is a good resource for this if you're having problems figuring out how to set up a SQL connection string.

For upward migration, take a look at the Access Upsize Wizard - this link is for 2002 since I'm not sure what access version you have.

If for some reason you do not have sufficient access to your SQL database to handle an upsize directly, you'll likely need to just generate the database schema and knock out a bit of migration code.

edited Dec 3, 2010 at 17:37

answered Dec 3, 2010 at 10:10

Bob Palmer

4,7722 gold badges30 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David-W-Fenton Over a year ago

The SQL Server Migration Assistant for Access is vastly superior to the upsizing wizard (though still not without it's own issues).

HMP · Accepted Answer · 2010-12-03 10:10:56Z

0

If you have access 2007, there is inbuilt option convert access database to SQL other wise there are somany tools available for free.

bullzip free converter

answered Dec 3, 2010 at 10:10

HMP

312 bronze badges

Comments

awrigley · Accepted Answer · 2010-12-04 13:06:26Z

0

Try MUST

It was developed by a colleague of mine (we designed the website: www.upsizing.co.uk).

It does a fair bit more than the MS tools.

answered Dec 4, 2010 at 13:06

awrigley

13.6k11 gold badges88 silver badges129 bronze badges

Collectives™ on Stack Overflow

Convert Access data base to SQL Server

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related