Download the product delivery file
Extract the delivery file and find the data text file
- Download the Create Table script
Open the Create Table script in a text editor and confirm that the table name is set to serviceability_extended_attributes
- If a new format (FMT) file needs to be created, please follow the steps found in https://msdn.microsoft.com/en-us/library/ms191516.aspx
- Issue the following
bcp <database_name>.dbo.<table_name> format nul -c -f <path>\format_file_name.fmt -t " " -S -T
-T: Specifies that the bcp utility connects to SQL Server with a trusted connection using integrated security. If
-Tis not specified, the
-Pparameters for username and password must be passed in order to log in.
-t " ": Specifies that the format file will be generated using the tab delimiter.Example:
bcp serviceability_extended_attributes format nul -c -f C:\ serviceability_extended_attributes\serviceability_extended_attributes.FMT -t " " –S –T
Note: Once the format file has been generated, \r needs to be removed from the file in order to load data successfully.