Column Addition

Goal: Add a column in the defined table in database and then export the data in the modified table.

Input: Download table with additional column and data from here.

Connection String: Data Source=(local)\SQLEXPRESS;Integrated Security=True;User ID=SheetKraft;Initial Catalog=testdb1
Table Name: "dbo"."product"

Hint:

  1. Open SQL Management server, and connect with the local database.
  2. In the left column Object Explorer, go to Databases -> testdb1 -> Tables -> dbo.product, right click on dbo.product and then select Design.
  3. A query window will open with columns Column Name, Data Type and Allow Nulls
  4. In the empty row at the bottom, enter the details for the new column.
  5. Save the query.
  6. Open the excel containing the data, use the UI ExportToDatabase.SK, connect to the relevant datasource using above given connection string.
  7. Search for the given table by clicking on Table Name [horizontal dotted button].
  8. Select the relevant Operation, eg: "Table Replace".
  9. Check the columns to be exported.
  10. You can also check the output checkbox (for any column) if you want see the uploaded data.