Regarding Adopting A prior database / site to ASP.NET

Last post 05-22-2009 10:47 PM by b471code3. 1 replies.

Sort Posts:

  • Regarding Adopting A prior database / site to ASP.NET

    05-22-2009, 2:25 PM
    • Member
      point Member
    • Rahloman
    • Member since 05-22-2009, 6:17 PM
    • Posts 1

    Greetings to all of you out there.

     I'm posting this topic to hear if it's possible to adopt Joomal or PHPNuke to a MSQL database, or in anyway get them to communicate with one another ?

     You see, I'm about to try and take on a job, where I need to make a new program, with more space to get http://www.7thcavalry.us/modules.php?name=MILPACS&file=soldierprofile&uniqueid=659 and http://www.7thcavalry.us/modules.php?name=MILPACS&file=roster to work from it current database, over to MSQL, WITHOUT having to start from scratch.

     If this is possible, I'd enjoy any help I'd be able to get.

     Signed

     Rahloman

  • Re: Regarding Adopting A prior database / site to ASP.NET

    05-22-2009, 10:47 PM
    • Contributor
      5,247 point Contributor
    • b471code3
    • Member since 02-27-2007, 12:44 PM
    • SE Minnesota
    • Posts 1,065

    Usually you can come up with some ODBC connectors to get the two to "talk" together.  Now if you want to fully migrate from MySql to MS SQL then your data conversion will be a lot of work.  If you plan to keep the same schema then you should be able to utlize some of the generated SQL statements from MySql to generate your MS SQL database and tables.  Importing and exporting will take some practice and patients but it will come. 

    Key is to determine if it will be beneficial to have 2 databases and have them connected via ODBC or just bite the bullet and migrate it to MS SQL.  Either way, it will be some work for you. 

     

    View Brenden Kehren's LinkedIn profileView my profile
    Remember to mark as answer if this post answered your question or solved your problem.
Page 1 of 1 (2 items)