Hello all,
I have to test the migration script to see if the script I created is working with no issues for having this I ask the DBA team to create the same schema as other users and Import the table structure with all constraints So that I can execute the script to migrate data from the Legacy system if any issue comes I can change the script.
The DBA is unwilling to create the duplicate user and wants me to create backup tables and test my migration script, but when I create the tables, the constraints on that table need to be modified, and so many issues.
Please suggest to me how I can convince the DBA?
Here what I am looking for
+ Schema_Name
- Tables
+ Table A
+ Table B
+ Table C
+ Views
+-----
+------
+ Other Users
- New_User
- Table A
+ Table B
+ Table C
Thank you,