Importing Table - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Importing Table

Author

Topic

Keshaba
Yak Posting Veteran

52 Posts

Posted - 2009-02-05 : 09:21:45

Hi I am using sql server 2005 express.How shall I import Table from Database name ABC to Database name Media

Keshab

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-05 : 09:45:32

BCP,LINKED SERVER.

X002548
Not Just a Number

15586 Posts

Posted - 2009-02-05 : 09:46:13

SELECT * INTO Media..Table FROM ABC..Table

It will bring data and the table, but nothing else

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-05 : 12:49:14

are dbs on same or different server?

Keshaba
Yak Posting Veteran

52 Posts

Posted - 2009-02-07 : 07:30:24

Database is on The same server

Keshab

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-07 : 08:49:58

then use Bretts suggestion