Restore missing SQL Views and reset column default values
$30-250 USD
Suoritettu
Julkaistu yli 10 vuotta sitten
$30-250 USD
Maksettu toimituksen yhteydessä
We have a database that is missing about 40 SQL Views that need to be restored and hundreds of columns in various tables whose default values need to be reset. For some reason they came over into a new database with the value of ' ' (with a space), rather than '' (two single quotes with no space). We need someone to read the original database, figure out which SQL Views are missing out of about 600, and restore those views in the new database. We also need someone to fix the default values in the columns where the value needs to be reset. We have a script that will identify the specific ones. Looks like a few hundred of these columns.