Can I export a sample data of one database and import them to another?
Hi All,
Thank you for reading this thread in advance.
One day I was asked 'if the data volumn in PROD database is too huge to be fully-exported to DEV database, what should I do to make the SQLs written in DEV behave the same as they do in PROD'?
In my understanding, if the DEV has already had the sample data in it, we then can export/import the statistics from PROD to DEV.
Am I correct here? Please correct me if not.
But what can I do if no data in DEV( for example, DEV is a brand new and empty database) ? Does export utitlity has the paratermeter like 'just export 20% or (more or less) percentage of whole volumn of data' ?
Thank you for reading this thread in advance.
One day I was asked 'if the data volumn in PROD database is too huge to be fully-exported to DEV database, what should I do to make the SQLs written in DEV behave the same as they do in PROD'?
In my understanding, if the DEV has already had the sample data in it, we then can export/import the statistics from PROD to DEV.
Am I correct here? Please correct me if not.
But what can I do if no data in DEV( for example, DEV is a brand new and empty database) ? Does export utitlity has the paratermeter like 'just export 20% or (more or less) percentage of whole volumn of data' ?
0