How to copy data of Sqlserver 2000 to MySql

**thatsrohit** · May 23 '07, 01:41 PM

Hi , I need One Help

I have one database(bibleG allery) which is in sql server2000.
with eight tables

1) tblArtists,
2) tblBasePrice,
3) tblcategories,
4) tblPricegroup,
5) tblProducts,
6) tblProductsType ,
7) tblRetailProduc ts,
8) tblUserDetails

i have to develop one application which do following tasks

step1-- convert sql server 2000 database to mySql database

step2-- now if i had made any changes to sqlserver 2000 database than
compare both database and make same changes in mySql or can
Mark changes in sqlserver and only marked data send back to MySql

So Please find out the way to solve this problems and tell me its Urgent.