• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

How to move table from one database to another database in sql server 2000

How to move table from one database to another database in sql server 2000

Any help will be greatly appreciated
0
royalcyber
Asked:
royalcyber
3 Solutions
 
Atlanta_MikeCommented:
In enterprise manager, Right mouse click on the database the table exists in. Go to all tasks, Export Data and follow the prompts in the Export Data wizard
0
 
MageDribbleCommented:
have you tried DTS?  it's actually very easy to do in DTS.

OR you can do a query:

SELECT *
INTO <DatabaseToCopyToName>.dbo.tablename
FROM tablename
0
 
royalcyberAuthor Commented:
would you know how to use DTS
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
MageDribbleCommented:
DTS is all prompts.  Just follow the prompts and you can just click click your way to copying.  The above query also works and is just as easy if you are familar with SQL.
0
 
royalcyberAuthor Commented:
I tried using DTS and it works fine but I just want to move the table and not the data, do you guys know how to do that in DTS, Thanks
0
 
ptjcbCommented:
You right-click on the table, choose Tasks, Generate Script. Choose whether you want to script the primary keys, indexes, etc. Click Preview and there is the script for the table. Copy that script to Query Analyzer. Connect to the new database. Run the script.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now