Overview
The SQL Data Tools API provides programmatic access to features within SQL Data Tools. This allows you to automate tasks, integrate SQL Data Tools with other applications, and create custom solutions.
Data Import and Export
This section covers the API functions for importing and exporting data between SQL Data Tools and external sources.
ImportData
Imports data from a file or database into SQL Data Tools.
ImportData(string filePath, string connectionString, string tableName)
Parameters:
filePath: The path to the data file.connectionString: The connection string to the data source.tableName: The name of the table to import the data into.
Schema Management
This section covers the API functions for managing the schema of databases within SQL Data Tools.
CreateSchema
Creates a new schema within SQL Data Tools.
CreateSchema(string schemaName)
Parameters:
schemaName: The name of the schema to create.