Back Up and Restore with merge and duplication check
-
3. srpna 2012 8:38
Hello,
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)
Všechny reakce
-
3. srpna 2012 12:29
Hi Bhargav,
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)
http://www.simple-talk.com/sql/t-sql-programming/removing-duplicates-from-a-table-in-sql-server/
Kindly revert for any more info.
- Chintak (My Blog)
- Navržen jako odpověď ryguy72 6. srpna 2012 13:50
- Označen jako odpověď Iric WenModerator 12. srpna 2012 9:03
-
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!!
Ryan Shuell
