Activity overview
Latest activity by davidf
Set delete option off for many tables?
three questions1i have many tables to populate, but the system defaults to delete old data. how can i untick the delete before generation option for multiple tables?2How can i set a value for a p...
hi David, thanks for your really quick response! i am referring to sql data generator, where is there a comparison results screen there?. for my second question, no, the columns already exist in every table / comments
hi David, thanks for your really quick response! i am referring to sql data generator, where is there a comparison results screen there?. for my second question, no, the columns already exist in...
also, how can i set a value for a particular column in every table, without having to going into each table. for example, every table has a column called entity status and its value must be between 0 and 4, randomly. how can i universally set the conditions for this column in each of my many tables? / comments
also, how can i set a value for a particular column in every table, without having to going into each table. for example, every table has a column called entity status and its value must be betwee...
How can i set delete off for multiple tables?
i have many tables to populate, but the system defaults to delete old data. how can i untick the delete before generation option for multiple tables?
hi @David_D i have another question, if i have an index on a view that needs to be created on an existing view, why does the view have to be dropped in its entirely? this is a problem for me because if the index already exists then nothing should be done (and save the customer upgrade time). is there not a setting to not drop views and just add an index if it doesnt exist? david / comments
hi @David_D i have another question, if i have an index on a view that needs to be created on an existing view, why does the view have to be dropped in its entirely? this is a problem for me becau...
Hi david thanks for responding. I understand what u say but my question is different. i need an option called "force exclusivity" or something like that.... This is my desired use case:
Customer makes a mess of one of my table structure by adding junk indexes but refuses to send a sql compare snapper schema for comparison.
the table cannot be dropped and recreated because it has data.
i create a script with sql compare of how the table should look exactly.
i send the script to the customer, and after he has run it, the table is exactly as i want it to be, without his junk indexes i.e. the sql compare deployment script deleted any junk the customer may have added to the table.
/ comments
Hi david thanks for responding. I understand what u say but my question is different. i need an option called "force exclusivity" or something like that.... This is my desired use case:
Custom...
Can sql compare force a set of indexes on a table, no matter what indexes were there before
updating my customers (police forces) is a one way street, it is not possible to get them to reliably send me information or to run snapper so i can compare the databases. They also have a habit ...