Hello /g/.
I came here to ask for some advice about azure and powershell.
I need to make a powershell script that copies one SQL database from a SQL server to another SQL server.
Is there any way I can do this with powershell?
>Pic unrelated, obviously
>>62061514
also the sql servers are in two different resource groups.
Oh and I only need to copy the structure of the database.
I don't really need the entries in the tables, just the structure.
>>62061525
Then just use SSMS or T-SQL with sqlcmd/osql. There is no reason to bring powershell in to play here.
>>62061655
Yeah I could use that but ..umm...
I am working on a project where you have a webapp in azure as a 'template' and you have to basically clone it programatically.
For example I have the webapp "Template" and I wanna do one of those for Nestle so I clone the "Template" with the name "Nestle", and the PS script has to make a resource group, copy webapp, storage, SQL server, SQL database, service plan and also change the web config to make it work.