Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
evertheory
Starting Member
1 Post |
 Posted - 2001-04-06 : 04:24:14
|
| 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.evertheory |
|
|
|
|
|
Data is being copied instead of overwritten