Examples of systems and method for data transition are described. In an example, the present disclosure provides for automating the process of data movement from on premise to cloud, i.e., source Data warehouse (DWH) movement, ETL to cloud base DWH, ETL. The present disclosure provides for objects identification, metadata extraction, automated data type mapping, target data definition script creation, data extraction in bulk using source native optimized utilities, users and access control mapping to the target DWH, binary object movement, end-end audit report, and reconciliation reports.