SLQ Studio dropping keys on data import

Posted on 2008-02-02
Medium Priority
Last Modified: 2013-11-30
I appear to be having a problem with sql server management studio with sql2000. If I use the data import to bring over a table from an existing database it appears to be drop identity columns and keys. Anyone see this and know a fix
Question by:bensonwalker
  • 2
LVL 60

Expert Comment

ID: 20806661
Not exactly sure what you mean. I am familiar w/ the data import not popogating keys, such as primary keys, foreign keys, indexes....but I think that the identity columns stay as identity columns.  One way to get around this is to script the table out as it is from the source server, execute that script on the destination server, then just import the data into that new table structure.  That should take care of what you need.

Author Comment

ID: 20807261
enterprise manager with 2000 never had this problem. Is this just another "enhancement from Microsoft"
LVL 60

Accepted Solution

chapmandew earned 100 total points
ID: 20807916
:)  Could be.  

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question