search

anthonydresser / testissues

0 stars 0 forks source link

In ADS on a Mac: Unable to load profile file #5001

Open anthonydresser opened 3 years ago

anthonydresser commented 3 years ago

Steps to Reproduce:

  1. Open a sqlproj in ADS
  2. Make sure you have a sql server running locally with a db you can deploy to
  3. After updating the db name, intial catalog, user name, and password, save the text below as dev.publish.xml
  4. Right-click the project and choose publish
  5. Click the folder icon in the dialog and browse for the dev.publish.xml file created in step 4
  6. app will prompt to connect to sql server
  7. toast at bottom right will show "unable to open profile file".

<?xml version="1.0" encoding="utf-8"?>

Database_Name Script.database.sql Data Source=(LOCAL);Initial Catalog=NAMEOFDATABASE;User id=USER;Password=TYPEPASSWORDHERE True False False 1 False False False False False False False