Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[suggestion] Run from command line #381

Open
simplesi opened this issue Oct 31, 2023 · 0 comments
Open

[suggestion] Run from command line #381

simplesi opened this issue Oct 31, 2023 · 0 comments

Comments

@simplesi
Copy link

SQL4CDS is such a great tool for dealing with the many nuances of Dataverse without directly wrangling the WebAPI. Thank you.

  1. I'd love to be able to execute a script from the command line, and hence add to some of our Azure Devops pipelines. There are quite a few things around the management of Master Data for example where the aging Configuration Migration Tool doesn't cut it but a SQL4CDS script can work, especially where you need to translate between source and target ids.
  2. Ideally this would also include some way to easily install the executable and dependencies on an Azure Devops Hosted image; maybe this is trivial with the msi or nuget package you already provide?
  3. This would likely need a way to substitute server aliases on the command line, e.g. we could specify which connection strings mapped to [target] and [source] below:
INSERT [target].dbo.contact (name)
SELECT name 
FROM [source].dbo.contact
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant