0

I want to migrate the data from Cosmos Table API to a json file.

I have copied the PRIMARY CONNECTION STRING from the portal and this is the command I am trying to run from using the migration tool:

dt.exe /s:DocumentDB /s.ConnectionString:"PRIMARY CONNECTION STRING" /s.Collection:application /t:JsonFile

OR:

dt.exe /s:DocumentDB /s.ConnectionString:"PRIMARY CONNECTION STRING;Database=TablesDB" /s.Collection:application /t:JsonFile

and I receive this error:

Critical error: DocumentDB account end-point URL should be provided as part of the connection string

What am I missing?

Angela
  • 477
  • 1
  • 10
  • 20

1 Answers1

0

Critical error: DocumentDB account end-point URL should be provided as part of the connection string

Based on this error,the account url is lack in the connection string.You could follow the example from this link:

dt.exe /s:JsonFile /s.Files:.\Sessions.json /t:DocumentDBBulk /t.ConnectionString:"AccountEndpoint=;AccountKey=;Database=;"

Please check the AccountEndpoint= in your connection string and try again.

Jay Gong
  • 23,163
  • 2
  • 27
  • 32
  • I want to move from Cosmos Table API to a json file. – Angela Oct 03 '19 at 05:45
  • I want to move from Cosmos Table API to a json file. But you gave me the answer I needed here: https://stackoverflow.com/questions/58202455/cosmos-table-api-perform-custom-scheduled-backup – Angela Oct 03 '19 at 05:50
  • Command to export data from Table API to json file: dt.exe /s:AzureTable /s.ConnectionString:"Connection String" /s.Table:application /s.InternalFields:All /t:JsonFile /t.File:application.json – Angela Oct 03 '19 at 05:51
  • @Angela Your error indicates that you provided uncomplete connection string,i just wanna suggest you checking the connection string. – Jay Gong Oct 03 '19 at 07:17
  • The problem was that I was using /s:DocumentDB instead of /s:AzureTable – Angela Oct 04 '19 at 10:10