Rank: Member
Joined: 2/1/2005(UTC)
Posts: 6
|
We are customizing the Import Tool and are ready to start testing. We expect to have to upload our test data multiple times during testing but don't want to create duplicate records each time. Does anyone have a script that will cleanly delete all products? Thanks.
|
|
|
|
|
|
Rank: Member
Joined: 10/28/2003(UTC)
Posts: 168
|
I have a few.
Depending on how many tables you are touching.
OR
Backup & Restore DB. |
|
|
|
|
|
|
Rank: Member
Joined: 2/1/2005(UTC)
Posts: 6
|
Thanks for the response. What do you need to know in order to determine if you have a script we can use? Or maybe you can send them over and we will figure out if they will work for us.
Happy Holidays!
|
|
|
|
|
|
Rank: Member
Joined: 7/21/2005(UTC)
Posts: 320
|
Dave, did you get an answer to this? |
|
|
|
|
|
|
Rank: Member
Joined: 8/20/2008(UTC) Posts: 81 ![United States]( "United States") Thanks: 2 times
|
Does anyone have a script? |
|
|
|
|
|
|
Rank: Member
Joined: 4/10/2009(UTC)
Posts: 120
Location: Mechanicsville, VA
Thanks: 3 times
Was thanked: 1 time(s) in 1 post(s)
|
Basically, you need to delete all rows from all of the product tables. There are 3-4 of them, and probably need to be done in order. Just a guess. |
Tim
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Use the BVC 2004 to BV5 migration tool. Point it to an empty BVC 2004 database and select "clear all products before import". Everything is cleared out, nothing imported.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.