Migrate Access database to SQL Server

[rnooraei]

Hi
I would like know what will be involved to migrate from Access database to SQL Server database. My application it works based on windows authentication. Any help appreciated

Thanks

 

[jmeckley]

this is better suited for forum183 or forum962

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[jshurst]

That is a very broad question. It could be as simple as running an SSIS package and changing the connection string, or it could be complicated because of bad data in the Access db that won't convert.

It is very possible, and sometimes easy, but there is not way to give you an accurate reply.

 

[rnooraei]

Hi Jason,
I used ASP.NET 2.O to build my application that why I am not sure I only need to change connection string and reconnect the SqlDataSource to SQL Server ....

Thanks

 

[jmeckley]

ok, but migrating a database and updating a connection string for a GUI are totally different.

For help migrating the db see the forums listed above.
For help altering asp.net code use this forum.
For help with VB.Net in general (not specific to asp.net) see forum796

Jason Meckley
Programmer
Specialty Bakers, Inc.