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
where whatever = whatever;
Last Wiki Answer Submitted: October 14, 2008 3:58 pm by Sqloholic25 pts.