My needs are for transfering 50 tables from one server to another one. I use the transfer management interface of SQL Entreprise Manager (Database/Object Transfer). I scheduled the transfer by night under the scheduled task feature. My problem is the transfer for the first 20 tables are working but after that the transfer stopped and i have nothing on the log explaining that. We have SQL Enterprise manager 6.5 and the service pack 4.0 is installed.
Do you have any idea about this problem or another technique for transferring tables or do you know a third party product?
Note: The replication is not a solution for us