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
 Import/Export (DTS) and Replication (2000)
 about export and import

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-23 : 09:40:52
Prashanth writes "i have enterprise manager ms sql utility
how ca i export some tables from one database to another by using query analyzer support ?"

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-08-23 : 10:46:54
u can use import export wizard (u can find it in the Programs --> SQL Server .... or u can go to the tables in Database and rightclick on that where u find Import & Export on the Top.

or if u want to do it in Query Analyzer (by writing queries) u can do it
U may need to tell us more details about the SQL server / databases / Tables and what data is needed to be moved etc

Srinika
Go to Top of Page
   

- Advertisement -