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

SQL Server 2000 copy table data and structure

SQL Server 2000:

I would like to copy data, primary keys, identitiy columns, default values, etc from a particular table (products) and make a copy of it on another SQL server.

Please advise how can this be accomplished.

Would DTS be the simplest way to go? or is there a quicker and cleaner way to do this?

Thanks.
 
0
Ricky66
Asked:
Ricky66
  • 2
  • 2
1 Solution
 
cyberkiwiCommented:
Is this in the wrong zone? 2005/2008

I believe you need to generate the script for the table (include all constraints, indexes, defaults) and run it at the target first.
DTS can then transfer the data.
0
 
Ricky66Author Commented:
Sorry but I couldn't find a zone for SQL Server 2000. How can I generate a script for the table (including all constraints, indexes, defaults) ?

Thanks.
0
 
cyberkiwiCommented:
In Enterprise Manager, right click on the database. One of the options is to Generate SQL Scripts
0
 
Ricky66Author Commented:
Thank you. Appreciate your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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