3. srpna 2012 8:38
Back Up and Restore with merge and duplication check
I want to backup of my database and at time of restore i dont want to loss my old data i want to update database.How it is possible…?
Currently in my application i take backup in XML file and while restore i loop through cursor…and Read XML file data one by one table’s Row…
It takes too much time…..
give me better solution… pls….
- Přesunutý Bob BeaucheminMVP 4. srpna 2012 4:03 Moving to a more relevent forum for best response (From:.NET Framework inside SQL Server)
3. srpna 2012 12:29
Looks like you creating a copy of a data as XML then parse through XML and load data back into the table while checking for duplicate data.
This is not not called BACKUP and RESTORE in SQL. In SQL, Backup creates a transactionaly consistent copy of database which can be used to create a same database.
If you want to remove the duplicate rows from table, below contains many solutions (last one is the most preferred one)
Kindly revert for any more info.
- Chintak (My Blog)
6. srpna 2012 13:49
Wow. For deleting dupes, that is one of the most comprehensive blogs I have ever seen. Thanks for sharing this useful resource!!