I am trying to copy a Database from one server to another with backup and restore. The problem is that after restore when I compare the 2 databases I found some difference between Source DB and target DB.
I know its seems strange but its a fact.
I comprea the DB with SqlCompare and SqlDatacompre.
No . there where no changes, how ever the differnce between the 2 dataase are changes that were made a few hours b4 backup was taken.
I though it might have somthing to do with checkpoint so I run the command checpoint on database before backup and even shutdown the server itself ,however same results. I don'n know if its matter but recovery model is SIMPLE (it is a development DB)
Well the prolem with the copy wizard is that if I want to copy it to a differnt name I can't do it . if for example I have 2 servers srv1 with db1
and srv2 with db1 and I want to create on srv2 a db called db2 which is copy of srv1.db1 I have to rename Databases and I want other people no DBA to be able to do it with one click
I am a part of a project develpment team , the projects has 2 databases
one is a metadata DB and one is the application DB changes made in metaData shold be transfer to Testint and QA enviroments till now we did it with DTS that moved the Data but this process had to remove FK and than Rebuild them so I thought Backup /restore will be better but then I found the diffrences so maybe I 'll go back to the DTS even if I don't like it