Hi frends Any one having idea about this task please help me
We would have the same database schema in Production and Development as well for an application
the data that is there is production is real time and the data in the Dev is test data or development data.
right now the requirement is on a daily basis, I want the data from Production to the Dev database .. say today I restored a backup of production database to Dev.. both the databases would have same data right
tomorrow, you might have new data into the production database ,which is not in the Dev database.. so that differential data (the data that is loaded for that particular day i.e today to tomorrow) should be created as back up and it should be restored to the Development database