Click here to Skip to main content
15,940,271 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

 
Share this answer
 
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
 
Share this answer
 
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.
 
Share this answer
 
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