Hey,
I am trying to create a Windows Scripting Host app that will create a result set from one SQL table, and then store those results in another SQL table (which a differnt schema). This might sound like a really odd question, but hang on
We have a database that is corrupted, we can read some of the records, but before a full recordset is returned, we get a torn page error.
I am hoping to have some way of getting what I can into a disconnected recordset, and then storing what I can get into another table (with a different name/schema) to our new recovery DB instance.
I can get the records out of the DB into the recordset, but cant find a way to then stick those records into another table out of the recordset.
I know in ADO.Net you can have multiple Tables in a DataSet, and can do what I am essentially wanting (add the two tables to the DataSet, popuplate the source table, append the data to the destination table, then push the destination table, with new records, back to its source)... but havent found a method of doing this via ADO (I cant use ADO.Net in windows scripting Host).
Any help would be appreciated, and I am pretty sure the solution to this would make a great FAQ (I have seen it asked many times on the net, but have yet to find an answer).
Tj
I am trying to create a Windows Scripting Host app that will create a result set from one SQL table, and then store those results in another SQL table (which a differnt schema). This might sound like a really odd question, but hang on
We have a database that is corrupted, we can read some of the records, but before a full recordset is returned, we get a torn page error.
I am hoping to have some way of getting what I can into a disconnected recordset, and then storing what I can get into another table (with a different name/schema) to our new recovery DB instance.
I can get the records out of the DB into the recordset, but cant find a way to then stick those records into another table out of the recordset.
I know in ADO.Net you can have multiple Tables in a DataSet, and can do what I am essentially wanting (add the two tables to the DataSet, popuplate the source table, append the data to the destination table, then push the destination table, with new records, back to its source)... but havent found a method of doing this via ADO (I cant use ADO.Net in windows scripting Host).
Any help would be appreciated, and I am pretty sure the solution to this would make a great FAQ (I have seen it asked many times on the net, but have yet to find an answer).
Tj
