79492115

Date: 2025-03-07 11:22:44
Score: 1.5
Natty:
Report link
>Using Azure, how do I copy data from one database to another on different servers without changing the schema?

**Follow the below steps to copy data from one database to another database on different servers without changing the schema:**

**Step:1**
Open **SSMS** and right click on database and select `General Scripts`.
![enter image description here](https://i.imgur.com/lPd8LKh.png)

**Step:2**
    Click on  `Select specific database objects`. Now click on `Select All` and click on`Next`. ![enter image description here](https://i.imgur.com/roTLGlm.png)
    
**Step:3**
Select `Open in new script Window` and click on `Advance`.![enter image description here](https://i.imgur.com/NT4w6nb.png)

**Step:4**
Select `Type of data to script` , `schema and data` and click on `OK`.
![enter image description here](https://i.imgur.com/fJqQ7OC.png)

**Step:5**
Click `Next`, In the save script click on `Save Report` and `Finish`.![enter image description here](https://i.imgur.com/Ti0tiV4.png)

Upon clicking "Finish," I will open the script in the SSMS Query Editor, as demonstrated below:
![enter image description here](https://i.imgur.com/vzNoisa.png)

Copy the above script and execute it on a different server database. Upon successful execution, it will create the schema along with the data, as illustrated in the image below.
![enter image description here](https://i.imgur.com/0QAMDm9.png)
Reasons:
  • Blacklisted phrase (1): how do I
  • Blacklisted phrase (1): enter image description here
  • Long answer (-1):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Narendra Reddy Pakkirigari