none
Migrate a C# Code from MS Access to SQLServer ? RRS feed

  • Question

  • Hi, i have deve loped a project based on C#, and MS Access AS DBMS, now i need to migrate to SQL server, how i can modified the source code of dataset generated by designer assistante, i mean a OleDb projet to SqlClient project, is there any tools or technics or a way?
    Monday, July 25, 2011 5:51 PM

Answers

  • Do you wish to continue to use the designers?  Or are you looking to decouple your datasets from your application tier? 

    I guess if you just want to replace the database but return to using the designers, then can't you just setup a new data connection to the new database and re-map everything to the new datasets?  Sorry, I am really not that familiar with the data designers.

    You may want to consider that there is significant value in creating seperation between your data and app tiers (and this value is blarringly apperant in your case as you are finding out how difficult it can be to modify your app since your data tier has changed!).  Have a look at Bonnie' series of posts regarding techniques to break you free from the designers, yet retain the benefits of Strongly Typed Datasets:

    http://geek-goddess-bonnie.blogspot.com/2009/09/dataaccess-part-i.html
    http://geek-goddess-bonnie.blogspot.com/2009/10/dataaccess-part-ii.html
    http://geek-goddess-bonnie.blogspot.com/2009/10/dataaccess-part-iii.html

    I have been using this technique for some time now and it makes perfect sense when considering architecture for your application.


    James Crandall ~ http://javitechnologies.com Spatial Database Solutions
    • Marked as answer by saimmmms Tuesday, July 26, 2011 3:39 PM
    Monday, July 25, 2011 6:14 PM

All replies

  • Do you wish to continue to use the designers?  Or are you looking to decouple your datasets from your application tier? 

    I guess if you just want to replace the database but return to using the designers, then can't you just setup a new data connection to the new database and re-map everything to the new datasets?  Sorry, I am really not that familiar with the data designers.

    You may want to consider that there is significant value in creating seperation between your data and app tiers (and this value is blarringly apperant in your case as you are finding out how difficult it can be to modify your app since your data tier has changed!).  Have a look at Bonnie' series of posts regarding techniques to break you free from the designers, yet retain the benefits of Strongly Typed Datasets:

    http://geek-goddess-bonnie.blogspot.com/2009/09/dataaccess-part-i.html
    http://geek-goddess-bonnie.blogspot.com/2009/10/dataaccess-part-ii.html
    http://geek-goddess-bonnie.blogspot.com/2009/10/dataaccess-part-iii.html

    I have been using this technique for some time now and it makes perfect sense when considering architecture for your application.


    James Crandall ~ http://javitechnologies.com Spatial Database Solutions
    • Marked as answer by saimmmms Tuesday, July 26, 2011 3:39 PM
    Monday, July 25, 2011 6:14 PM
  • thank you for your  coucils, it's the best time to attack, beaucause , i have passed the last night, all the night, doing the convertion, thank you.
    Tuesday, July 26, 2011 3:39 PM