search

PeterHenell / sql-server-data-producer

Automatically exported from code.google.com/p/sql-server-data-producer
0 stars 1 forks source link

Option to truncate the table before running the script #11

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
I want to make sure that my scripts will not fail.
Add an option to delete existing data and reset all identity seeds to their 
default values.

If there are foreign keys that would prevent this, then give me a warning and 
option to delete those referencing tables aswell (recursivly?)

Original issue reported on code.google.com by a03pe...@gmail.com on 28 May 2012 at 11:48

GoogleCodeExporter commented 9 years ago 
This should only happen once, before the generation starts.

Script failure will cause the target database to be empty.

Original comment by a03pe...@gmail.com on 30 May 2012 at 2:12

GoogleCodeExporter commented 9 years ago 
visible option and backing property added to allow the option to truncate the 
table.

For complete fix I will need to implement some kind of workflow management.

Original comment by a03pe...@gmail.com on 30 May 2012 at 4:25

GoogleCodeExporter commented 9 years ago 
Each execution item now have the option to truncate the target table before 
running the insertions.

Original comment by a03pe...@gmail.com on 8 Jun 2012 at 10:34