| Data is duplicated in the table when uploading to the SQL server ( Help?) [message #373249] |
Fri, 06 April 2001 03:14 |
Eric
Messages: 78
Registered: April 1999
|
Member |
|
|
Anyone who uses SQL 7 or 2000 I have a goofed somehow.
While importing and exporting using the enterprise manager in SQL 7 for some reason when I import the new tables to the server it is not over-riding the current items, but in fact duplicating them! The database has over 1600 items but now it has 3200.
This is my first time uploading the database, but it is very urgent due to the amount of traffic we get.
Our site programmer is no longer with us and I have to do this myself now.
All I did was pull down the database, added 100 new items, and them uploaded the database using the data transformation wizard.
How do I import without having the table data duplicated.
Im very desprate and any help would be appriciated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
