I want to move some data from my prod database to my test database via SQL Data Compare. I would like to set this up to run regularly. However I do not want to move email addresses from prod into test, but I need a fake email in that column. Is there a way to put fake data in during the move, but use the real data for the rest of the columns?
SQL Data Compare - Can I randomize a column's value before moving the data over?
32 Views Asked by John At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in REDGATE
- Flyway clean command failing on snowflake with ASSOCIATE_SEMANTIC_CATEGORY_TAGS' does not exist or not authorized
- SQL Data Compare - Can I randomize a column's value before moving the data over?
- Initialize empty database from SQL scripts generated by Redgate SQL Source Control
- Trying to connect snowflake using flyway-migration
- SQL Server error 0x5 (15404) - could not obtain information about Windows NT group/user
- Redgate SQL Search - How can you search for exact phrases with symbols?
- Is Red Gate SQL Test tSQLt version the same as in GitHub?
- ERROR: Flyway Teams Edition upgrade required: jdbc-secretsmanager is not supported by Flyway Community Edition
- How can I remove tool generated columns named createdby updatedat etc
- Redgate SQL Toolbelt components are not installing in Jenkins inbound-agent windows docker image
- MSSQL DB Multi-Table Export to Excel Issue
- Redgate SQL Source Control: ignoring Database Roles
- Data migration for .SQB files to Snowflake
- SonarQube Analysis on Pull Request and not during build pipeline
- Does Redgate change automation tool builds repositories containing procedures with JSON functions in them?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
No. You can't modify the data as part of a Data Compare run. The tool is really simple & straightforward, compare two things, spot the differences, move the differences. That's it.
You could look to a tool like Data Masker to modify the data after Compare has moved it. Other mechanisms are also available before or after Data Compare is used, but Data Compare just doesn't do that kind of work.