Convertion of access database to sql using coding

Question

For my asp.net program I need to convert access database to sql. Manually I can do it my convertion in the sql. But it is very difficult. I need this convertion daily. So is there any code in asp.net to convert it to sql database. pls help.

Answer 1

Yes, as per Nitin, you can use SSIS which load the MS Access data to SqlServer.

 

If you are not comfortable with SSIS then create windows service which will run daily basis and do the job. Means everyday it will create an .sql file and then execute the sql file in server.

Answer 2

May be you should look into SQL Server Integration Services (SSIS).

Answer 3

Hi,<br><br> Please go through below thread-<br> http://stackoverflow.com/questions/10577237/ms-access-to-sql-sever-in-c-net