So, what's the problem? please specify that I assume your question is how do you move data directly from 1 database to another? Actually, Mr. Denny taught me this just a couple of weeks ago. It is really easy. Here's the syntax (assuming you're logged on to the database where the data is currently located): Insert into other_serverother_database.table_name select column1, column2, column3 from original_table where whatever = whatever;

So, what's the problem? please specify that I assume your question is how do you move data directly from 1 database to another? Actually, Mr. Denny taught me this just a couple of weeks ago. It is really easy. Here's the syntax (assuming you're logged on to the database where the data is currently located): Insert into other_serverother_database.table_name select column1, column2, column3 from original_table where whatever = whatever;