Hi Currently I am accessing remote data base for my project. I am connecting it through VPN (cisco). Although its serving my purpose but I am facing some other performance issues. So I am planing to transfer the data I required from the remote data base to my local database. Can anybody help me in 'How to transfer data from remote data base to local data base'. My remote database server is Microsoft SqlServer2000 and Local is Mysql server5.0
Do you mean a one-time transfer or a perpetually (nightly/hourly) transfer? The first being easy with the use of database exports/imports built into the database software, while the latter being a much more complicated issue.