Guest_imported
New member
- Jan 1, 1970
- 0
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.
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.
