Click here to Skip to main content
15,845,681 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
If i have two azure sql databases.. One is called FROM and the other one is called TO

The from database has some certain things that i need to copy to the TO database

I created a new stored procedure
Where it has some selects using the FROM db and based on some conditions I need to insert values to the TO database tables

However it seems this is not supported. Even though it worked by copying from a local DB to another local DB

What I have tried:

Is it doable to copy the data and do some inserts using the stored procedure?
Updated 27-Dec-21 1:18am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900