Creating a test schema - what is the best practice?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-24-2023 12:00 AM
- Hey,
I've created a schema with few tables with historical data (prod), now I would like to have a Dev/testing environment with exactly the same data.
What do you recommend? CTAS? Shallow clone? Deep clone? I wonder if shallow clone would be sufficient, what is your experience?
