how to export one table of a DB to another

Hi Experts,

I have a DB and a table inside.
How to export this table to another DB on another server ?
Eprs_AdminSystem ArchitectAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Leo TorresSQL DeveloperCommented:
If the databases are on the same network right click the Source Database --> Click Task--> Export data.

This will open a wizard point it to the destination server and then the destination database.

and your done
Leo TorresSQL DeveloperCommented:
My instructions pertain to sql 2005 2008, 2012
Aneesh RetnakaranDatabase AdministratorCommented:
there are different options,
1. from SSMS , right click on the source database -> tasks -> export data
 on the pop up , select the data source as the sql native client , make sure that the server name and the database are the source server and the database ; choose the destination as again the SQL native client,  click next choose the default copy data  and click next
Choose the source table and click next and run immediately
if the table exists in the destination, you may need to go back to the previous step and click on edit mapping and make appropriate changes there.
Lee SavidgeCommented:
If it's a one off job then this will do:

-- execute in database containing table you wish to copy

select * into myotherdatabase..mynewtablename from mytable

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Lee SavidgeCommented:
Obviously you will need the correct permissions on the target database for the executing user.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.