Skip to main content
S
ssailer
Inspiring
May 7, 2008
Question

SQL Server - Import Data

  • May 7, 2008
  • 2 replies
  • 913 views
When I create a SQL Server database on my ISP's server, and import the data from my local SQL Server database, why is the Identity field always set to NO on the imported data tables, even though it is set to YES on my local copy? This happens for EVERY TABLE and it's getting really frustrating!
This topic has been closed for replies.

2 replies

T
The_ScareCrow
Inspiring
May 26, 2008
I assume your using the import wizard ?

When you get to the page where you select the tables (from - to) on the far right there is an elipse button.
Click this and check out this form very closely.

Ken
S
ssailerAuthor
Inspiring
June 6, 2008
I don't see this option in SQL Server 2000. I do not see any elipse...???
R
RyanLeTulle
Participant
May 20, 2008
One other option is to backup the database and then restore it on the new server. This will maintain the identity fields.
S
ssailerAuthor
Inspiring
June 6, 2008
I can't back up and restore on the server because the drives are different and I do not have access to the drive that they store files on. Unless there is something that I am missing...???
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices