Syncing data from mysql to mssql using php

[macinslaw]

I'm probably in the wrong area, if so, then please correct me.

 

Issue:

 

I am developing a database for our inventory.  This is a master list of all hardware as well as their relationships, will track when they arrive to when they are recycled.  This database will be in mssql.

 

I currently have helpdesk software that does some inventorying, however, it only handles up to 100 items and regardless, it must match and reflect the current inventory.  I am making a php site to perform the entering of the hardware, however I need a way for it to be able to add/remove anything in the helpdesk inventory automatically.  This helpdesk inventory database is in mysql.

 

I'm not the most advanced at sql commands, this is why I need your assistance.

 

-Mac

[yacahuma]

if you are developing it now, why use mssql(microsof sql server ,right).  Do you find you have a limitation with mysql?

[macinslaw]

No...no limitation, other than my boss prefers to be an all MS shop.  I was able to get this helpdesk software in and running on Mysql, because of it's cheap cost, but there is a serious limitation to the inventory tracking in the software.  So to combat it, I have to make a mssql counterpart.  My boss knows mssql and not mysql, and again he prefers to stay mostly MS.

 

Believe me, I wish I could just use mysql, it would make this a lot easier.

 

I need to take the list in mssql and compare it to mysql.  If the list is different, I need it to add or remove anything that is different.

 

Can you help?

[darkfreaks]

post the code so we can convert it to MSSQL thank you

[macinslaw]

No offense, but if I had the code I wouldn't need the help! 

 

I am not used to working with many to many type situations, I usually design databases and code in such a way that I deal with a single location and a single result 9 times out of ten and I steer clear of situations where I have to take many items and mtch those items in another location and manipulate them, mainly because I don't understand how it works.

 

Let's make it even simpler...I need help understanding what I need to write in order to take 100 records in one database and match them to another database making updates and deletes as necessary in the second database to make it match the first.  Let's just imagine they are both mysql databases.  If I can understand how to write it in mysql, I should be able to convert part of the code for mssql.

 

Thanks.