I have recently asked to build and maintain the databases for an established online retailer. The plan is to build the tables and "storefront" using php and MySQL which I am familiar with and eventually move everything over to my hosted server. However, in the mean time, we need to maintain the current databases to keep the operation going until we're ready to move which may be a month out.
I'm gaining bits and pieces from the person I am replacing who I believe is hosting the site right now. I was told that I would need "a MS Entreprize manager software to access it." Not sure if Enterprize is spelled correctly or not. I looked around even on the Microsoft website and have not been able to find anything that looks like what I need. I'm assuming this is sort of like a phpmyadmin type program that lets you interface with the databases.
Is this correct? Could anyone lead me towards a good, preferable free program to use. As I'm only going to be needing this for a month or so to keep the catalog updated, I don't want to waste a ton of time learning a new platform. Just need to be able to perform updates on a MS SQL 2000 database.
I won't say I'm an expert with MySQL, but with phpmyadmin, I am able to get the job done and write the appropriate php code to maintain my tables.
Any guidance would be appreciated.