Migrate data from production database to testing database
-
Dear All, We have below requirement kindly suggest the best solutions. Requirement : Extract specific data from the production database and need to load those data to test environment database. For example, in production database has 100 tables, need to exact 40 tables with specific data ( Don't want to extract all data only few data based on input rule). Kindly suggest best solution to avoid huge effort. Thank you in advance. Best Regards
-
Dear All, We have below requirement kindly suggest the best solutions. Requirement : Extract specific data from the production database and need to load those data to test environment database. For example, in production database has 100 tables, need to exact 40 tables with specific data ( Don't want to extract all data only few data based on input rule). Kindly suggest best solution to avoid huge effort. Thank you in advance. Best Regards
Well, it would help to know what database you are using.... Don't you have any kind of database backup in place? Can't you just sue that to populate your test database? But anyway, most databases have admin tools that allow you to export data in one form or another... and failing that, you could always write your own script to create a bunch of SQL INSERT statements....
-
Dear All, We have below requirement kindly suggest the best solutions. Requirement : Extract specific data from the production database and need to load those data to test environment database. For example, in production database has 100 tables, need to exact 40 tables with specific data ( Don't want to extract all data only few data based on input rule). Kindly suggest best solution to avoid huge effort. Thank you in advance. Best Regards
Is this MS SQL Server you are referring to? If so you can use the SSMS Wizard to set up a package to export the data - very easy to use and once the package is in place you can tweak it if you need to use it again... We had a similar set up on our Test database (so that we could change it without having to have update permissions on Production)
