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!

creating new database and transfering the data?

Status
Not open for further replies.
nowayout

nowayout

Programmer
Feb 25, 2003
364
US
Hi all,


I am trying to create new test db and for that i am importing the data from original database, it gets data from import wizard but while importing data it creates table too but i am not getting the Primary Key which is in the original database. What can it be done Please thanks

Suggestion?

Thanks again
 
Status
Not open for further replies.

Similar threads

ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
191
gk53
gk53
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
147
botatun
botatun
arodri
  • Locked
  • Question
MSVisual Studio - DTSX Package creating new text file
Replies
0
Views
152
arodri
arodri
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
283
markjoseph1232
markjoseph1232
johnb1023
  • Locked
  • Question
Date conversions between Microsoft SQL Server and Viewing in MS Access
Replies
0
Views
229
johnb1023
johnb1023

Part and Inventory Search

Sponsor

Back
Top