Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS & Autonumeric fields - SQL 2000 to SQL 7 "export"

Status
Not open for further replies.
jjanczuk

jjanczuk

MIS
Dec 14, 2002
2
AR
I'm trying to export a SQL 2000's database to a SQL 7 Server.

With DTS, all seems fine, except that my SQL2K autonumeric fields are created as "stantard" (no auto-) numeric fields in SQL 7.

Any ideas to solve this?

Thanks in advance.
Juan.
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Truncated Excel Fields
Replies
0
Views
190
grnzbra
grnzbra
petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
158
petart
petart
jeffwest21
  • Locked
  • Question
BCP Out file with double quotes
Replies
1
Views
248
gk53
gk53
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
74
mutley1
mutley1
Azzuri
  • Locked
  • Question
DTS To SQL Server 2008
Replies
1
Views
105
mrdenny
mrdenny

Part and Inventory Search

Sponsor

Back
Top