Link to home
Create AccountLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Azure copying SQL database to local machine

Hi

I want to create a back up of my Azure SQL database and then import it into my local SQL, but there seems to be an issue with the passwords, which I would noit want on my local machine.

I back up my Azure SQL database using "Export data tier application"

The connection string is a typical Azure one "      <add name="DefaultConnection" connectionString="Server=tcp:xxxxxx.database.windows.net,1433;Initial Catalog=xxxxx;Persist Security Info=False;User ID=admin;Password=password;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;" />"


The connection string that I am using for my local DB is "Server=(localdb)\\MSSQLLocalDB;Database=Quantum2;Trusted_Connection=True;TrustServerCertificate=True;"



Avatar of Allan
Allan
Flag of United States of America image

Hi Murray, so what's the problem? and can you please walk us through your steps? Thanks!

Avatar of Murray Brown

ASKER

I have in my question. I really just want to know that if you export an Azure database with a username and password and then import to your local sql do you have to use the username and password. If so how would the connection string look

SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
ASKER CERTIFIED SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.