Click here to Skip to main content
15,300,338 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi All,

I want to design a software migrate the MS Access Database to SQL Server by using C#. But now i don't have any solutions for my problem. So if you have an ideal or soure code for my problem, pls let me know.

Thanks.
Posted

   
Comments
Member 11405963 28-Jan-15 1:49am
   
Thanks,
but i need a sample code to migrate the MS Access Database to SQL Server by using C# without tool.
Mathew Soji 28-Jan-15 3:43am
   
Try using SqlBulkCopy Class .

https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx
Member 11405963 29-Jan-15 2:14am
   
Thank you! using SQlBuklCopy is the best way to copy the large amount of data to the sql database
   
Comments
Member 11405963 28-Jan-15 1:49am
   
Thanks,
but i need a sample code to migrate the MS Access Database to SQL Server by using C# without tool.
   
Comments
Member 11405963 28-Jan-15 1:48am
   
Thanks,
but i need a sample code to migrate the MS Access Database to SQL Server by using C# without tool.
deepakdynamite 28-Jan-15 5:47am
   
Best of Luck !!!!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900