CODEWITHSUNDEEP
databasetestingsql-server-2012
Roman Pokrovskij
Roman Pokrovskij

Reputation: 9776

Simple and quick way to produce test database from production database?

Do we have any tool that can reduce data in the database, that means to create a test database? It could be a wizard with functionality: 1) choose tables that you want to "preserve" (like classificators) 2) choose table that you want to truncate and point the number of records that you want to left, then all "related" tables will be truncated by analyzing fk references. 3) repeat 2 by choosing another table

Upvotes: 0

Views: 109

Answers (1)

Sari
Sari

Reputation: 26

this looks like what you look for Jailer It exports consistent, referentially intact row-sets from relational databases.

Upvotes: 1

Related Questions