[RESOLVED] Access to SQL Server Migration

[zynder]

Hi guys. I used VB6 and Access 2003 for my backend. Now I want to migrate to SQL Server that will run through ODBC.

My first task is to convert my current Access dbase to SQL.

http://support.microsoft.com/kb/237980

But during the upsize wizard, I am lost. Im stuck with "Select Data Source" and "DSN name"? I am very new to this. Can you give me some helpful link on how to convert Access to MySQL Server and configure the ODBC.

I tried some links but didn't help me much. And one more thing, will the queries with the previous Access be the same? I hope that the only thing I will change are the queries and the connection strings.

I have Vb6 and SQL already installed on the server. Im really confused with the setup.

Guys, please lighten me up with this. Thanks!

[Hack]

Whenever I've had to do this I simply migrated the data from Access to SQL Server using a DTS package. I find that much easier to do.

[zynder]

Yeah I found a link using DTS.

http://msdn2.microsoft.com/en-us/lib...3(sql.70).aspx

Is it basically the same as using the Upsizing Wizard of Access? How do I setup the ODBC? Sorry Hack this is my first time to do this. Please bear with me.

[GaryMazzone]

You set up ODBC connections using the Data Sources application located in the Control Pannel (Administrative Tools) area.

[zynder]

What should I do first? Setup the ODBC or Migrate my Access to SQL Server?

Im currently running DTS and it says choose a destination. What should I choose?

Microsoft OLE DB Provider? or the ODBC?

[zynder]

I got it working guys. Thanks for the help.
I setup the DTS first then setup the ODBC.