Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
derick123
Starting Member
1 Post |
 Posted - 2008-03-25 : 07:54:24
|
| Hi guys,I am trying to transfer data from a table in a SQL server database to an equivilent table in a MYSql database that resides on a different server.I have previously used a php script to do the job but it proved very slow. I am dealing with a table that is growing and has 9.5 million records in this case and the proceedure may need to be carried out a number of times preday so I am hoping to find a better solution.I am wondering anyone can point me in the direction of an alternative method. Thanks,Derick |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-03-25 : 08:18:58
|
| DTS might be a worthy consideration. |
 |
|
|
|
|
|
Select into MYSql table