hi, i am currently building an application that depends on a third party application written in .net using a mssql server database. i am more of a lamp guy and prefer mysql. to extend the application i would need to add some tables to the database. i am currently thinking of creating my custom tables in mysql instead of adding new tables to the mssql db. i currently have to use free tds to communicate with the mssql da and that creates some challenges. is it better to leave the third party application alone using free tds to communicate with it and then create a new mysql db for my tables or to just have all data in one database, namely mssql, and just use free tds to communicate with all data? i would have to write an api to communicate with the db and also prefer to have this in php rather than .net.
cali_dotcom
0
Junior Poster in Training
Recommended Answers
Jump to PostAs long as you do not need to join tables between the two DBs, it's not a problem. The only disadvantage is the Managment of 2 DBs and extra connections but I don't foresee a noticeable performance issue because of it.
Jump to Postbetter to convert all to mysql
Convert a third-party existing .net application to mysql...?? Hardly possible.
you can not use limit in mssql
It's called
TOP
. For paging there are other solutions too.
All 5 Replies
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
vibhaJ
126
Master Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
vibhaJ
126
Master Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.