Home

Data Import for SQL Server

1. AWE 31 MS EXC6l2007 Vi e e ie Eee ede e e e eiue 32 MS Word 2007 re eR Pep A eod ve pc ep n p Dee re poer iu 35 MS ACCOSS WA mi Aa ume nete aite menn nte meleste 36 p n 37 MMe cst ote ed LOL Eh e AAA 39 XML DOC UImerit iis oa pedo tere te adn 40 TXT ias ERN ct d edes AA tese 42 43 EDI ee tne Ur Le een ce En orte Pere tree EC ANUANI errr E Ee op 45 op A A M 46 ODI A inedit cesi ava d A el de eae s 48 Step 5 Setting base data formats cin eel karaita 49 Format Specifier Saarani renes ett eue ERE 51 Step 6 Settings data formats for each field 54 Step 7 Specifying import mode inmi tanan nanne nnnm nnen ennnen nnmnnn nane 58 Step 8 Selecting Key c luMmNS ai BA e Fra Kasai Hasha iiSi esias haswaa 60 Step 9 Setting common options coonconcnnncnnnnnnnnnn nn 61 ECIHEDEPinnpIguc H 63 Step 11 Start of data import process csscsecsssesssesseesseesersneeeseseneerseeesnesseeeeeeseneseneseesseeseersnecseesseesseeseneeseens 64 Using data import configuration files manana manana nanunua makaka Kana nennt 66 Setting program preferences m ccccccocccocococonocononononononnnnonononononononononononononononanononnnnnonnnnonononnnns 68 GOTO ral ii KA
2. 68 EAN QUAQE S c 70 zar Jp mee 71 gt JRogijpLe ES 72 dora A 73 O 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual Part Ill Console application 76 Working with console application cccccccccccccccccccncccnccnonononononononononononononononononononnnonononenonona 77 Configuration file format Ia 78 Part IV Appendix 82 Supported file formats cccccccccccccccncncncnnnnnnonococonononononononononononononononononononnnnnnnnnnnnnnnnonenenenos 82 Add Edit AAA AYA AT APAA PU PA WAMA AI WAA CA AAA 83 Add Edit Range m Erie 85 1999 2014 EMS Database Management Solutions Ltd 6 Data Import for SOL Server User s Manual 1 Welcome to EMS Data Import utility EMS Data Import for SQL Server is a powerful program to import your data quickly from MS Excel Excel 2007 MS Word 2007 MS Access DBF TXT CSV Open Document HTML files to SQL Server tables It provides adjustable import parameters including source data formats for all the fields and destination data formats for the selected fields commit options number of records to skip etc Data Import for SQL Server includes a wizard which allows you to set all the import options for different files visually and a com
3. Fie CE CX Ex COUNTRY ls Y 121 CUSTOMER mdb v New fields Grid Column JA DEPARTMENT ods v film id VARCHAR 10 1 A DISCOUNTS odt Ed title E EMPLOYEE xlsx v i E JOB csv w El language id VARCHAR 10 El PAYMENT xm E original language id VARCHAR 10 PROJECT dbf i EX rental duration VARCHAR 10 K SALES html v BB rental rate DOUBLE En STORES txt Ed length VARCHAR 10 CITY ml EX replacement cost DOUBLE S Be 41 FILM docx Skip ine s 1 Table 1 film id title release year language id original lang rental durati rental rate length 1 ACADEMY 2006 1 null 6 0 99 86 2 ACE GOLDF 2006 1 null 3 4 99 48 3 ADAPTATIC 2 006 1 null 7 2 99 50 4 AFFAIR PRE 2 006 1 null 5 2 99 117 5 AFRICAN EL 2 006 1 null 6 2 99 130 6 AGENT TRL 2 006 1 null 3 2 99 169 Database DIOMED 7 AIRPI ANF t FNNA 1 null R 499 R x New table TESTERFILM m To remove a correspondence select the field in the New fields list and press the X Clear Field Ranges button To remove all correspondences press the _ e Clear All Ranges button Click the Next button to proceed to the Setting base data formats 49 step of the wizard 2 1 5 4 MS Access Set correspondence between the source MS Access fields and the target SQL Server table fields e select a field of the target SQL Server table in the Table fields list select the corresponding field of the source MS Access table in the Access Fields list cli
4. E Data Import for SQL Server Step 6 of 10 Select import mode Files Import mode CUSTOMER mdb Insert all Update Delete Ex C Insert new gt Update or insert gt Delete or insert A Native mode Universal mode Data Native mode kind mport for SQL Server 9 Single commands Bulk insert Y Keep identity Database DemoDB ESO New table dbo CUSTOMER SWP this step eb cto If the Update value is selected for Import Mode then you need to specify the Primary Key field s that will serve for data identification of your source file with the data of the target table The source file must contain the column s that will correspond to the Primary Key field of the target table If the target table contains a record in which the value of the primary key field coincides with the value of the corresponding column of the source table the data stored in this table record will be updated You can specify the field s which will be used for identification at Step 7 60 of the wizard This field s will only serve for identification and will not be imported 1999 2014 EMS Database Management Solutions Ltd so Data Import for SQL Server User s Manual Native Universal mode The Native mode uses the Single Commands method that serves to generate and execute single SQL commands on the server whereas the Bulk Insert mode uses native commands for a particular server BULK INSERT for Microsoft SQL Server
5. Data Pump for DB2 Migrate from most popular databases MySQL PostgreSQL Oracle MySQL InterBase Firebird etc to DB2 Data Generator for DB2 Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters s 4 B DB Comparer for DB2 Compare and synchronize the structure of your databases Move changes on your development database to production with ease 1999 2014 EMS Database Management Solutions Ltd 21 Data Import for SQL Server User s Manual DB Extract for DB2 Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially ES SQL Query for DB Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for DB2 Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to top 165 Tools 8 components Advanced Data Export Component Suite for Borland Delphi and NET will allow you to save your data in the most popular office programs formats pr Advanced Data Export Advanced Data Export NET E Advanced Data Export NET is a component suite for Microsoft Visual Studio NET 2003 2005 2008 and 2010 that will allow you to save your data in the most popular data formats for the future viewing modification printing or
6. See also How to register Data Import M2 1999 2014 EMS Database Management Solutions Ltd 12 Data Import for SOL Server User s Manual 1 5 Howto register Data Import To register your newly purchased copy of EMS Data Import for SQL Server perform the following e receive the notification letter from Share it with the registration info e enter the Registration Name and the Registration Key from this letter e make sure that the registration process has been completed successfully check the registration information at the startup pagel 24 Register Data Import for SQL Server mm Please enter the registration information you received when purchasing Data Import for SQL Server Registration Name Registration Key Bete ee ae See also How to buy Data Import ho 1999 2014 EMS Database Management Solutions Ltd 13 Data Import for SOL Server User s Manual 1 6 EMS Data Import FAQ Please read this page attentively if you have questions about Data Import for SQL Server Table of contents What is EMS Data Import for SQL Server 13 e What do I need to start working with EMS Data Import for SQL Server ha e What is the difference between the Import feature of SQL Manager for SQL Server and the Data Import for SQL Server utility 13 Are there any limitations implied in the trial version as compared with the full one 14 e What is the easiest way to configure the template files for th
7. VSIED210 1004 11 shipped 04 03 1991 05 03 1981 1 null y p V92E0340 1004 11 shipped 15 10 1992 1 16 10 1992 1 17 10 1992 1 y v92 1003 1010 61 shipped 26 07 1992 1 04 08 1992 1 15 09 1992 1 y V93J2004 1010 118 shipped 30 10 19931 02 12 19931 15 11 1993 1 y v93 3100 1010 118 shipped 20 08 1993 1 20 08 1993 1 null y VS2F3004 1012 11 shipped 15 10 1992 1 16 01 19931 16 01 1993 y E V93F3088 1012 134 shipped 27 08 1993 1 08 09 1993 null n Database DIOMED V93F2030 1012 134 open 12 12 1993 null null y v Table TESTER SALES 4 w I To remove all correspondences press the L jJ Clear All Ranges button Click the Next button to proceed to the Setting base data formats 49 step of the wizard 2 1 5 11 ODS The OpenDocument format is used by Mobile Office as well as other well known desktop applications such as OpenOffice StarOffice and KOffice ODS stands for OpenDocument Spreadsheet ods Specify ranges in the grid for the target and source fields e select a field of the target SQL Server table in the New fields list e proceed to the Sheet grid click a column to assign the column to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process If the source file and the destination SQL Server table have the same order of columns you can use the KAY Auto Fill Columns mode de
8. Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generall s section of the Preferencesles dialog When you are done press the Next button to proceed to the next stepl s4l 2 1 6 1 Format specifiers The following format specifiers are supported in the format string Float Integer format 0 Digit place holder If the value being formatted has a digit in the position where the O appears in the format string then that digit is copied to the output string Otherwise a O is stored in that position in the output string Digit placeholder If the value being formatted has a digit in the position where the appears in the format string then that digit is copied to the output string Otherwise nothing is stored in that position in the output string Decimal point The first character in the format string determines the location of the decimal separator in the formatted value any additional characters are ignored Thousand separator If the format string contains one or more characters the output will have thousand separators inserted between each group of three digits to the left of the decimal point The placement and number of characters in the format string does not affect the output except to indicate that thousand separators are wanted E Scientific notation If any of the strings E E e or e
9. Data Import for SQL Server User s Manual 4 2 Add Edit field When you import data with destination table creation you can manage this table s fields Use the context menu to Add Edit Drop a field Sj Add field Edit field 3 Drop field Selecting Add field or Edit field context menu item opens the field editor that allows you to view edit the properties of the destination table fields ES Edit Field mm Column NAME Type varchar Size 50 Scale Default value Seed Increment cmd Use the Column edit box to set the field name Note that the name of the field must be unique among all the field names in the table The Type tab defines the type of the field data Size Defines the size of the field value Scale For numeric and decimaltypes you need to define the number of decimal to the right of the decimal point Default value Define this option value if you need inserted records to get specified value Seed Specify the value used for the first row that is loaded into the table 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual Increment Specify the value added to the identity value of the previous row that is loaded Y Not NULL Check this option to prevent the entry of NULL or unknown values in column 4 Is Row Guid This option specifies that the ROWGUIDCOL property is added to the column ROWGUIDCOL indicates that the column is a row GUID c
10. Database DIOMED Table TESTER PROVEC Uso deleted rose 1999 2014 EMS Database Management Solutions Ltd 29 Data Import for SQL Server User s Manual To remove a correspondence select the pair of fields in the list below and press the Remove button To remove all correspondences press the Clear button Click the Next button to proceed to the Setting base data formats 491 step of the wizard 2 1 5 6 XML Set correspondence between the source XML columns and the target SQL Server table fields e select a field of the target SQL Server table in the Table Fields list e select the corresponding column of the source XML table in the XML Fields list e Click the Add button to set correspondence between the selected fields e the pair of fields appears in the list below e repeat the operation for all the fields you need to be included in the import process If new table creation was selected at the previous stepi then fields needed for the import procedure will be created automatically You can manage destination table fields s3l if needed Use the corresponded context menu item to Add Edit Drop field Bg Add field BB Edit field 3 Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross X Use the Autofill button to set correspondence between the source and target fields automatically on the basis
11. SQL Manager net EMS Database Management Solutions Data Import for SQL Server User s Manual 1999 2014 EMS Database Management Solutions Ltd Em3 SQLServer Data Import for SOL Server User s Manual 1999 2014 EMS Database Management Solutions Ltd All rights reserved This manual documents EMS Data Import for SQL Server No parts of this work may be reproduced in any form or by any means graphic electronic or mechanical including photocopying recording taping or information storage and retrieval systems without the written permission of the publisher Products that are referred to in this document may be either trademarks and or registered trademarks of the respective owners The publisher and the author make no claim to these trademarks While every precaution has been taken in the preparation of this document the publisher and the author assume no responsibility for errors or omissions or for damages resulting from the use of information contained in this document or from the use of programs and source code that may accompanyit In no event shall the publisher and the author be liable for any loss of profit or any other commercial damage caused or alleged to have been caused directly or indirectly by this document Use of this documentation is subjectto the following terms you may create a printed copy of this documentation solely for your own personal use Conversion to other formats is allowed as long
12. N l DEPARTMENT ods Thousand 160 Boolean false False A DISCOUNTS odt Ed EMPLOYEE xlsx Date Null values Null Est JOB csw a PAYMENT xml Time PROJECT dbf K SALES html Date formats E STORES t ia al CITY xml Date dd MM yyyy y 4l FILM docx Time h mm y Database DIOMED M ee Table TESTER COUNTA SP this step Separators Decimal Thousand Date Time Decimal Set a character to delimit the decimal parts of the imported numbers Thousand Set a character to separate the digit groups in the imported numbers Date Set a character to separate the year month and day parts of date values Time Set a character to separate the hour minute and second parts of time values Constants Boolean True Set one or more variants of TRUE value representation in the imported table e g Yes or F Use a new line for each additional variant Boolean False Set one or more variants of FALSE value representation in the imported table e g No or Use a new line for each additional variant Null Values Set one or more variants of NULL value representation in the imported table e g Null 1999 2014 EMS Database Management Solutions Ltd 51 Data Import for SQL Server User s Manual Use a new line for each additional variant Date Time formats Use these edit fields to set the date and time formats Date Time For more information refer to the Format specifiers 51 page Yi Skip this step
13. like structure of source document in the area located to the right from the New fields list Select a node in the tree to get its relative path or type the path manually in the editor below the path must be specified in the XPath format Upon pressing the Fill grid button the grid gets filled with Sub Nodes Text or Attributes values of the selected node Note if the source XML document contains huge amount of data building the tree may take a long time Set correspondence between the source XML file columns and the target SQL Server table fields e select a field of the target SQL Server table in the Fields list e proceed to the source grid viewer area click a column to assign the column to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process O 1999 2014 EMS Database Management Solutions Ltd a Data Import for SQL Server User s Manual You can use the EN Autofill button to set correspondence between the source and target fields automatically according to their order mapping is started from the first attribute value in this case When you import data to a newly created table the Analyze button appears Use this button for automatic field creation The number of the column which correspondence is set for are displayed at the Grid Column column You can use it for setting the fields correspondence
14. you can choose to skip a defined number of the source file rows using the Skip lines spin edit The number of the column which correspondence is set for are displayed at the Grid Column column You can use it for setting the fields correspondence as well Files 8 Je LJ e Ed COUNTRY xls Y m 21 CUSTOMER mdb y Fields Grid Column Delimiter y JA DEPARTMENT ods y 4 JOB CODE VARCHAR 5 1 Quote v A DISCOUNTS odt JOB GRADE SMALLINT 2 i E EMPLOYEE xlsx v 3 JOB COUNTRY VARCHAR 15 3 Encoding El JOB esv E JOB TITLE VARCHAR 25 4 Windows default v E PAYMENT xml 8 MIN SALARY DECIMAL 10 2 PROJECT dbf v 3 MAX SALARY DECIMAL 10 2 E SALES html v 3 JOB REQUIREMENT LONG VARC Em STORES txt ES LANGUAGE REO VARCHAR 91 E CITY xml 4l FILM docx Skipline s 1 E Column 1 Column 2 Colum 3 Column 4 Column 5 Colum amp Column_ Column_8 JOB CODE JOB GRADI JOB COUN JOB TITLE MIN SALAF MAX SALAF JOB REQUI LANGUA CEO 1 USA Chief Execul 130 000 00 250 000 00 No specific null CFO 1 USA Chief Financ 85 000 00 140 000 00 15 years in null VP 2 USA Vice Preside 80 000 00 130000 00 No specific null Dir 2 USA Director 7500000 120 000 00 5 10 years e null Mnar 3 USA Manager 60 000 00 100000 00 BA BS requ null Mngr 4 USA Manager 30000 00 60000 00 5 years offi null Database DIOMED Admin 4 USA Administrativ 35 000 00 55 000 00 3 5 years ex null T
15. 0 00 00 621 Eng 2 Kim Lambert 22 0 00 00 130 Eng 2 Leslie Johnson 410 0 00 00 180 Mktg 3 E 4 m h Database DIOMED To select the column dick its header To select the row dick its number To select several cells at once dick Table TESTER EMPLO the right cell and the last cell holding the Shift button To remove a correspondence select the field in the Fields list and press the x Clear Field Ranges button To remove all correspondences press the Clear All Ranges button If your spreadsheet file contains several sheets you are able to set different mapping for each sheet To clear ranges for a field select the field in the Fields list and press the Clear Field Ranges Lx button To clear all ranges specified for the target table fields press the Clear All ranges ES button To set a range of datal85 to be imported from the file use the Add range button To remove a range use the Delete range Le button Using the Move Up Le and the Move Down Le buttons you can change the order of ranges applied to data Click the Next button to proceed to the Setting base data formats 4 step of the wizard 1999 2014 EMS Database Management Solutions Ltd 35 Data Import for SOL Server User s Manual 2 1 5 3 MS Word 2007 Specify ranges in the grid for the target and source fields e select a field of the target SOL Server table in the New fields list e proceed to the Table grid click a column to assign the col
16. 15 Autofill TA PHONE NO Text 20 J is loci ER COUNTRY VARCHAR 15 o ADDRESS LINEi Text 30 2 Z EX POSTAL CODE VARCHAR 12 518 ADDRESS LINE2 Text 30 W FILM docx BR ON HOLD VARCHAR 1 E CITY Text 25 m El STATE PROVINCE Text 15 7 Table fields Access fields Hi CUST NO INTEGER CUST NO Number ER CUSTOMER VARCHAR 25 CUSTOMER Text 25 E CONTACT FIRST VARCHAR 15 CONTACT FIRST Text 15 CONTACT_LAST VARCHAR 20 CONTACT LAST Text 20 PHONE_NO VARCHAR 20 PHONE_NO Text 20 EX ADDRESS_LINE1 VARCHAR 30 ADDRESS_LINE1 Text 30 Ex ADDRESS LINE2 VARCHAR 30 ADDRESS LINE2 Text 30 Database DIOMED Table TESTER CUSTO To remove a correspondence select a pair of fields in the list below and press the Remove button 2 1 5 5 To remove all correspondences press the Clear button Click the Next button to proceed to the Setting base data formats 49 step of the wizard DBF Set correspondence between the source DBF columns and the target SQL Server table fields e select a field of the target SQL Server table in the Table Fields list 1999 2014 EMS Database Management Solutions Ltd 3 Data Import for SQL Server User s Manual select the corresponding column of the source DBF table in the DBF Fields list click the Add button to set correspondence between the selected fields the pair of fields appears in the list below repeat the operation for all
17. For your convenience the Connection timeout option is implemented set this option to optimize the performance of the utility upon connection to your instance of SQL Server Use the Command timeout option to set time available for command execution EZ Data Import for SQL Server kebas Step 1 of 11 Set SOL Server server connection options Authentication t B Host DOOM SERVER Pte ee SOL Server ED a Connection Timeout 15 sec Windows Data Command Timeout 30 2 sec Import Authentication for Login sa SQL Server Password Help Tools J lt lt Back Close Please note that you need to have sufficient privileges to be able to write to the destination database on SQL Server If you get any difficulties connecting to the database it can be useful to look through FAQs 13 When you are done press the Next button to proceed to the next step 2 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual 2 1 3 Step 2 Selecting files to import At this step you should select source file s to be imported Click the amp l Add File button to select the source file name using the Open file dialog Repeat this operation to add more source files if necessary You can choose among the following types of the source data file e MS Excel MS Excel 2007 MS Word 2007 MS Access DBF TXT CSV HTML XML Data Packet XML MS Access XML D
18. In the main file section the following parameters are used Database destination database name Table destination table FileName the source file name ImportType Indicates the format of the source file 0 stands for MS Excel 1 for MS Access 2 DBF 3 TXT 4 CSV 5 XML 6 MS Excel 2007 7 MS Word 2007 8 HTML 9 XML Document 10 ODS 11 ODT The next section is specific to the file format and is named correspondingly e g FILE 00 XLS In this section the following specific file type options are set FILE 00 XLS SkipRows SkipCols the number of rows and columns in the source file to be skipped on import FILE OO Access SourceType This option indicates the Access source type Table or query 0 stands for table and 1 for query TableName and query these options set the source Access table name to import from if source type is 0 and the source query text if the source type is 1 FILE OO TXT SkipRows the number of rows in the source file to be skipped on import FILE 00 CSV SkipRows the number of rows in the source file to be skipped on import CSVDelim iter CSVRightQuot CSVLeftQuot these options are used on reading the source CSV file they store options for delimiting columns and the quotation marks The next section is FILE XX MAP It is also specific to the file type but is obligatory for all file types In this section correspondence between the source file columns and the de
19. Server Supported MS SQL Server versions from 7 0 up to 2012 1999 2014 EMS Database Management Solutions Ltd 9 Data Import for SOL Server User s Manual 1 3 Installation If you are installing Data Import for SQL Server for the first time on your PC e download the Data Import for SQL Server distribution package from the download page available at our site e unzip the downloaded file to any local directory e g C unzipped run MsImportSetup exe from the local directory and follow the instructions of the installation wizard after the installation process is completed find the Data Import shortcut in the corresponding group of Windows Start menu Installation FAQs If you want to upgrade an installed copy of Data Import for SQL Server to the latest version e download the Data Import for SQL Server distribution package from the download page available at our site e unzip the downloaded file to any local directory e g C unzipped e close Data Import application if it is running e run MsImportSetup exe from the local directory and follow the instructions of the installation wizard See also System requirements 8 1999 2014 EMS Database Management Solutions Ltd to Data Import for SQL Server User s Manual 1 4 Howto buy Data Import To make it easier for you to purchase our products we have contracted with share it registration service The share it order process is protected via a secure connec
20. Sheet section to define the location of the row column for which the row was specified You can select either Default sheet or Custom Sheet For custom sheet you need to select Sheet Number or Sheet Name from the appropriate drop down list Note If Cell was set as Range Type the only thing you can specify at this dialog is its number 1999 2014 EMS Database Management Solutions Ltd ss Data Import for SOL Server User s Manual Credits Software Developers Alex Paclin Alexey Butalov Michael Kuzevanov Alexey Saybel Technical Writers Semyon Slobodenyuk Dmitry Doni Olga Ryabova Cover Designer Tatyana Mak urova Translators Anna Shulkina Serge Fominikh Team Coordinators Alexey Butalov Alexander Chelyadin Roman Tkachenko 1999 2014 EMS Database Management Solutions Ltd
21. are contained in the format string the number is formatted using scientific notation A group of up to four O characters can immediately follow the E E e or e to determine the minimum number of digits in the exponent The E and e formats cause a plus sign to be output for positive exponents and a minus sign to be output for negative exponents The E and e formats output a sign character only for negative exponents Date Time format 1999 2014 EMS Database Management Solutions Ltd 52 Data Import for SQL Server User s Manual c Displays the date using the format using the Short Date Format followed by the time using the Long Time Format The time is not displayed if the date time value indicates midnight precisely d Displays the day as a number without a leading zero 1 31 dd Displays the day as a number with a leading zero 01 31 ddd Displays the day as an abbreviation Sun Sat using the strings of the Short Day Names dddd Displays the day as a full name Sunday Saturday using the strings of the Long Day Names ddddd Displays the date using the Short Date Format dddddd Displays the date using the Long Date Format e Displays the year in the current period era as a number without a leading zero Japanese Korean and Taiwanese locales only ee Displays the year in the current period era as a number with a leading zero Japanese Korean and Taiwanese locales only g Display
22. as the actual content is not altered or edited in any way Document generated on 05 06 2014 3 Data Import for SOL Server User s Manual Table of Contents Part Welcome to EMS Data Import utility 6 AE EA SEI RIPE ceded sited he nade ete SHEIKH KASEKE SEHEM aie eee 7 System requirements cccccccccccccococonononononononononononononononononononononononononononcnnnnnonnnnnnnnnnnnnononnnnnnnns 8 installation Ino O A 9 How to buy Data Import cccccnmnccncncncncconnnnnnnnnanonnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnennnnnss 10 How to register Data Import ocococccononononononononononononononnnnnnnn nono nono nono nn nnn nnn nnns sss sans 12 EMS Data Import FAQ eeeeeeeeeeeeeeeeeeee nennen nnne nn nnn nn nn nnne nnne nn nn innu nnne nena nn 13 Other EMS Prod U CiS 5 ii aaae aa n aT acci a I eR ORI REA DIDRIR BAG GINE CA PRSE NRI Ka Ba BABE ENEA INS 16 Part Il Wizard application 23 Working with wizard application cccccccccccccccccncncccnnnnnnnonononononononononononononononononononnnononononona 24 GETTING SM ee 24 Step 1 Setting connection properties cnica 25 Step 2 Selecting files to import eleieieieeieessseesees eese ee eese te etna tentes insita anna naamka nnen mnene aan asma ansa tassa aaa 27 Step 3 Setting XML file type AKAA Haaa ea nnne anna insta ana ta assa Sasakwa asma KAB asma ata aa sana 29 Step 4 Mapping fields 21r rina ace erre id a 30 same
23. ata Import for SQL ServerLanguages French I C Program Files EMS D ata Import for SOL ServerLanguagessGerman C Program Files EMS Data Import for SQL Server Lanquages russian Language Directory C Program FlesiEMS Data Import for SQL Server Languages Language Directory Use the ellipsis L button to specify the directory where the ng files are stored by default See also Setting general options ee Setting data fonti Setting Excel options Defining interface style 23 Data Font The Data Fonts page is provided for setting up the fonts for displaying data in Data Import for SQL Server Set the appropriate font and the preferable charset using the corresponding drop down lists 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual v General yA Data Font Languages y Data Font Excel Options Interface Font B MS Sans Seti y Charset DEFAULT CHARSET Note that neither font nor character set changes can be applied to IKTHA files See also Setting general options see Selecting program language 70 Setting Excel options 72 Defining interface style 73 2 3 4 Excel Options The Excel Options page allows you to set the Max Col Width parameter which defines the maximum column width for Excel data grid 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual v
24. button to call the Select Table dialog again When you are done press the Next button to proceed to the next steph 2 1 4 Step 3 Setting XML file type This step appears if you have selected xml file for importing data from 1999 2014 EMS Database Management Solutions Ltd o Data Import for SQL Server User s Manual Files XML file 2 HR__DEPARTMENT_ mdt a m la HR_EMPLOYEE xml Auto Detect XML MS Access Q XML Data Packet XML Doc File Database DemoDB Tables HR EMPLOYEE XML file type Select the type of xml file from which you are importing data Auto Detect file type will be detected automatically whether it is XML MS Access or XML data packet file XML MS Access select this option if your xml file has the same structure as files exported from MS Access XML Data Packet select this option if your xmlfile has data representation format used by Embarcadero XML Doc File select this option to map fields of a Generic XML document 40 manually 2 1 5 Step 4 Mapping fields This step of the wizard allows you to set correspondence between columns of the source file and fields of the target SQL Server table according to the source data format MS Excel mappingi 311 MS Excel 2007 mappings MS Word 2007 mappingl35 MS Access mappingl 3e DBF mapping 37 XML mapping 3 XML Document mappingl40 IXTI mapping 42 CSV mapping HTML Document 45 ODS mappingl 481 ODT mappingl4
25. data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for SQL Server Compare and synchronize the structure of your databases Move changes on your development database to production with ease DB Extract for SQL Server Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for SQL Server Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for SQL Server Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to top 163 1999 2014 EMS Database Management Solutions Ltd 18 Data Import for SQL Server User s Manual PostgreSQL S9 SQL Management Studio for PostgreSQL EMS SQL Management Studio for PostgreSQL is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for PostgreSQL Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for PostgreSQL Export your data to any of 20 most popu
26. for SQL Server Business license 3 Year Maintenance EMS Data Import for SQL Server Non commercial license 1 Year Maintenance Buy Now EMS Data Import for SQL Server Non commercial license 2 Year Maintenance EMS Data Import for SQL Server Non commercial license 3 Year Maintenance EMS Data Import for SQL Server Trial version Download Now EMS Maintenance Program provides the following benefits e Free software bug fixes enhancements updates and upgrades during the maintenance period e Free unlimited communications with technical staff for the purpose of reporting Software failures e Free reasonable number of communications for the purpose of consultation on operational aspects of the software e Access to personalized sqlmanager net account online speed through maintenance renewal e Advanced and exclusive notification of software promotions 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server User s Manual e Maintenance Owner ONLY product promotions After your maintenance expires you will not be able to update your software or get technical support To protect your investments and have your software up to date you need to renew your maintenance You can easily reinitiate renew your maintenance with our online speed through Maintenance Reinstatement Renewal Interface After reinitiating renewal you will receive a confirmation e mail with all the necessary information
27. import into the selected field Press the Add Replacement E3 button to specify a new replacement options using the Add Replacement dialog Define the text to replace and the value to replace with in the appeared dialog window Check the Ignore Case option to make replacement case insensitive ra Replacement H Test to find ITman Replace with IT Manager DK Cancel To remove a replacement select it in the list and click the Delete Replacement button 1999 2014 EMS Database Management Solutions Ltd s Data Import for SQL Server User s Manual WI Skip this step Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generall s section of the Preferencesfea dialog When you are done press the Next button to proceed to the next stepf581 2 1 8 Step 7 Specifying import mode This step of the wizard allows you to define the records processing mode as Insert All Insert New Update Update or Insert Delete Delete or Insert mode e Insert all all records from the source file are inserted into the tables irrespective of whether any records exist in the destination table or not e Insert new already existing records are skipped and new records are inserted into the destination table Update all existing records are updated from the source file Update or insert already existing records are updated a
28. of their order Encoding Use this field to select the file encoding 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server User s Manual Files New fields XML fields E COUNTRY xls w E LAST UPDATE TIMESTAMP PAYMENT ID Integer 121 CUSTOMER mdb Y CUSTOMER_ID Integer JA DEPARTMENT ods v E Integer DISCOUNTS odt ZI RENTAL ID Integer EF EMPLOYEE xlsx v AMOUNT Float ET JOB csv Y Remove Ed PAYMENT_DATE DateTime 2 PAYMENT am LAST UPDATE DateTime PROJECT dbf v K SALES html w L 3 STORES t Encoding Windows default z 2 CITY xml 100 FILM docx Table fields XML fields Edd PAYMENT ID INTEGER PAYMENT ID Integer 8 CUSTOMER ID INTEGER CUSTOMER ID Integer 3 STAFF ID INTEGER STAFF ID Integer 8 RENTAL ID INTEGER RENTAL_ID Integer 3 AMOUNT DOUBLE AMOUNT Float F PAYMENT DATE TIMESTAMP PAYMENT_DATE DateTime Database DIOMED New table TESTER PAYME To remove a correspondence select the pair of fields in the list below and press the Remove button To remove all correspondences press the Clear button Click the Next button to proceed to the Setting base data formats 49 step of the wizard 2 1 5 7 XML Document In order to set mapping of a Generic XML document you should first select the desired XML Document in the Files list then press the Build Tree button to get the tree
29. the Long Time Format am pm Uses the 12 hour clock for the preceding h or hh specifier and displays am for any hour before noon and pm for any hour after noon The am pm specifier can use lower upper or mixed case and the result is displayed accordingly a p Uses the 12 hour clock for the preceding h or hh specifier and displays a for any hour before noon and p for any hour after noon The a p specifier can use lower upper or mixed case and the result is displayed accordingly ampm Uses the 12 hour clock for the preceding h or hh specifier and displays the contents of the TimeAMString global variable for any hour before noon and the contents of the TimePMString global variable for any hour after noon 1999 2014 EMS Database Management Solutions Ltd s Data Import for SQL Server User s Manual Displays the date separator character using the Date Separator Displays the time separator character using the Time Separator XX XX Characters enclosed in single or double quotes are displayed as is and do not affect formatting 2 1 7 Step 6 Settings data formats for each field This step of the wizard allows you to set formats for each imported field separately in case additional formatting is required Select a field in the list and use the Field Customization group to adjust format options that will be applied to this field only generator value generator step constant value NULL value d
30. the fields you need to be included in the import process If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fieldsls3 if needed Use the corresponded context menu item to Add Edit Drop field Sj Add field ES Edit field 3 Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross X Use the Autofill button to set correspondence between the source and target fields automatically on the basis of their order Charset Use this field to specify the source file character set Skip deleted rows Use the option to exclude records marked as deleted in source DBF file Files Fields F fields COUNTRY xls w Eb PRODUCT VARCHAR 12 EG PROJ ID Char 5 21 CUSTOMER mdb v 3 PROJ NAME Char 20 JA DEPARTMENT ods v Autofil Ed PROJ DESC Memo Zi DISCOUNTS odt i TEAM LEADE Number 11 0 EMPLOYEE xlsx v Ei PRODUCT Char 12 E JOB csv Y 4 PAYMENT xml PROJECT dbf Y VE SALES html v STORES txt lt one Iz 4 CITY xml WE FILM dacx Table fields DBF fields ES PROJ ID VARCHAR 5 PROJ ID Char 5 Ex PROJ NAME VARCHAR 20 PROJ NAME Char 20 Ed PROJ DESC LONG VARCHAR PROJ_DESC Memo TEAM LEADER SMALLINT TEAM LEADE Number 11 0
31. 20 EF STORES txt e CITY xml 81 FILM docx o E Sheet1 DEPT_NO DEPARTME HEAD DEP MNGR_NO BUDGET LOCATION PHONE_NO 000 Corporate Hi null 105 1 000 000 01 Monterey 408 555 12 100 Sales and M 000 85 2 000 000 01 San Francisc 415 555 12 1600 Engineering O00 2 1100 000 0 Monterey 408 555 12 900 Finance 000 46 400 000 00 Monterey 408 555 12 180 Marketing 100 null 1 500 000 01 San Francise 415 555 12 L 620 Software Prc 600 null 1 200 000 01 Monterey 408 555 12 Database DIOMED R71 Software Die RAN muli ANN nnn nn antaras ANAI RRR 17 YA Table TESTER DEPARTA M a To remove a correspondence select the field in the New fields list and press the Xx Clear Field Ranges button To remove all correspondences press the _ e Clear All Ranges button If your OpenDocument Spreadsheet file contains several sheets you are able to set different mapping for each sheet Click the Next button to proceed to the Setting base data formats 4 step of the wizard O 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server User s Manual 2 1 5 12 ODT The OpenDocument format is used by Mobile Office as well as other well known desktop applications such as OpenOffice StarOffice and KOffice ODT stands for OpenDocument Text odt Specify ranges in the grid for the target and source fields e select a field of the target SQL Server table in the New fields list e proceed to the Table gri
32. 8 1999 2014 EMS Database Management Solutions Ltd 31 Data Import for SQL Server User s Manual To get more information about the file formats see the Supported file formats s2 page When you are done press the Next button to proceed to the next step 49 2 1 5 1 MS Excel Select the needed source file from the list Then specify ranges in the grid for the target and source fields e select a field of the target SQL Server table in the Fields list e proceed to the Sheet grid click a column caption to select the whole column or click the row number to select the whole row the selected column row of the source file gets green highlight and a new range indicating the source and target fields correspondence appears in the Ranges list e repeat the operation for all the fields you need to be included in the import process If the source file and the destination SQL Server table have the same order of columns you can use the L8 Auto Fill Columns mode default to set correspondence between them automatically If source file and destination SQL Server table have different order of columns but identical names you can use the L amp r Auto Fill by Captions mode to set the correspondence based on name s identity You can also use the 2 KWA fill Rows to set the correspondence between destination table fields and source file rows If new table creation was selected at the previous stepl27 then fields needed for the im
33. General 3 mL Excel Options anguages Data Font Excel Options Max Col Width 64 amp Interface See also Setting general options see Selecting program language 70 Setting data font 71 Defining interface style 73 2 3 5 Interface This page allows you to customize the application interface style to your liking Use the Scheme name drop down list to select an interface scheme according to your liking Classic Office XP style Windows XP native style etc 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual General 9 Languages amp Data Font amp Excel Options a Interface Scheme name Officel1 Sample button Sample text edit Sample check box Sample button edit Sample combo box Item 1 Item 2 Item 3 Sample text memo edit 9 Sample radio button Sample group 4 Sample check box 1 4 E Sample check box 2 _ Sample check box 3 E Tree list item 1 Tree list item 2 Tree list item 3 For your convenience the previews illustrating the changes are displayed in the Sample Group area See also Setting general options see Selecting program language 70 Setting data font 71 Setting Excel options 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual 3 Console application Additionally to the GUI ve
34. TRY sql he Database DIOMED A Table TESTER COUNTA SKP this step WI Skip this step Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generall s section of the PreferencesTes1 dialog O 1999 2014 EMS Database Management Solutions Ltd 5 Data Import for SOL Server User s Manual When you are done press the Next button to proceed to the next steples 2 1 11 Step 10 Defining scripts This step of the wizard allows you to define scripts to be executed before and after import process for each database Select a database to define the script for Type the text of the script to be executed before the import operation in the Before Import Script area the script to be executed after the import operation in the After Import Script area Select another database and add scripts for it if necessary You can also save and load Before Import and After Import scripts using the corresponding Save Script and Load Script buttons Specify the script that vill be executed BEFORE data import After import script Specify the script that vill be executed AFTER data import 7 Skip this step Skip this step Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generalle8 section of the Preferences 68 dialog 1999 2014 EMS Database Manageme
35. With the help of the Native mode your data can be imported dozen times faster as compared to the Universal mode which is used for backward compatibility For the Universal mode Cursor location needs to be defined either Server or Client Vi Keep Identity This option specifies that the values for an identity column are present in the file being imported v Keep Nulls This option specifies that NULL columns should retain a null value during the bulk copy operation rather than have any default values for the columns being inserted Y Fire Triggers This option specifies that any insert triggers defined on the destination table will execute during the bulk copy operation Bulk Insert File Name Type in or use the ta button to specify the name and path to the bulk insert file name using the Save As dialog If data_file is a remotely stored file specify the Universal Naming Convention UNC name Bulk Insert Field Terminator Specify the field terminator to be used for char and varchar data files VI Truncate Long Strings If this option is enabled the long strings are truncated This option is available only in the Universal mode V Skip this step Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generalles section of the Preferencesles1 dialog When you are done press the Next button to proceed to the next stepleo 2 1 9 Ste
36. able TESTER JOB SL WJ tas To remove all correspondences press the Clear All Ranges button If you choose to import data to the newly created table at this step you need to create necessary fields Use the corresponded context menu item to manage fields 83 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server User s Manual Bg Add field Edit field 3 Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross X Click the Next button to proceed to the Setting base data formats 49 step of the wizard 2 1 5 10 HTML Set correspondence between the target table fields and the source HTML file columns e select a field of the target SQL Server table in the New fields list e proceed to the source grid viewer area click a column to assign the column to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process If the source file and the destination SQL Server table have the same order of columns you can use the ia y Auto Fill Columns mode default to set correspondence between them automatically If source file and destination SQL Server table have different order of columns but identical names you can use the 13 Auto Fill by Captions mod
37. aption fields JIOSO E 8 S IS aj yse 100 r rows E Import to views Y Keep options at steps Default min length for new string field o E Allow script execution Show databases Exdude autoincrement fields v V Remember password Setting this option allows you to save passwords used for access to the databases automatically upon closing the application Please note that checking this option saves the latest password used for connection to the database Y Show field types Hides displays field type description in the field list Y Show number of created tables Use this option to allow disallow appearance of the correspondent information window Y Show number of mapped columns Displays the number of mapped fields on proceeding to Step 3 30 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual 2 3 2 i Use first row as caption fields Enable this option to use first rows as captions when mapping fields Analyse N rows Define the amount of rows used for source data analysis before table creation This analysis allows the program to define the destination table field type v Import to Views By setting this option on you can import data to views they will appear in the list of available tables at the Step 2 24 of Wizard Application 23 Vi Keep options at steps If this option is checked all your import settings will
38. as well If necessary you can choose to skip a defined number of the source file lines using the Skip Lines spin edit m L8 JUX JU Jj Build tree Ed COUNTRY xIs v 121 CUSTOMER mdb v New fields Grid Col xsi noNamespaceSchemaLocation JA DEPARTMENT ods v city id DOUBLE 3 av DISCOUNTS odt city VARCHAR 21 4 dty id EMPLOYEE xlsx T country id DOUBLE 5 2 P Ed JOB csv v last update VARCHAR 15 6 lut tede E E PAYMENT xml la m PROJECT dbf Y K SALES html v dataroot CITY STORES tat Sub Nodes Text Fill grid 2 CITY xml pom Wi FILM docx Skip line s 0 z Node name Text city id city country id last update CITY 1 0000004 1 000000 A Corua La 87 000000 15 02 2006 E CITY 2 0000004b 2 000000 Abha 82 000000 15 02 2006 CITY 3 0000004b 3 000000 Abu Dhabi 101 000000 15 02 2006 CITY 4 000000Ac 4 000000 Acua 60 000000 15 02 2006 CITY 5 0000004d 5 000000 Adana 97 000000 15 02 2006 CITY 6 000000Ad 6 000000 Addis Abebe 31 000000 15 02 2006 CITY 7 0000004d 7 000000 Aden 107 000000 15 02 2006 Databases DIOMED CITY 8 0000004d 8 000000 Adoni 44 000000 15 02 2006 New table TESTER CITY CITY S 000000Ah 8 000000 Ahmadnaga 44 000000 15 02 2006 ia To remove all correspondences press the Clear All Ranges button If you choose to import data to the newly created table at this step you need to create necessary fields Use the corresponded context menu item to ma
39. button which calls the Save As dialog Save template options E3 File name C EMS docs TestTemplate itm ta Cancel Help If you need to repeat data importing process with the same or similar settings later it is reasonable to save all the settings you entered on the Start of data import process 6 step of the Wizard Please note that loading a template is only available at the Getting started 24 and the Setting connection properties 25 steps of the Wizard If necessary you can reopen a template at any step of the wizard using the corresponding popup menu item of the Tools menu Load Template M Preferences Reopen Template gt C EMS docs TestTemplate itm C EMS docs HR_import itm C EMS docs DEMO itm 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual See also Working with wizard application 24 Setting program preferences es 1999 2014 EMS Database Management Solutions Ltd e Data Import for SQL Server User s Manual 2 3 Setting program preferences Data Import for SQL Server provides full customization of the program interface by setting various options within the Preferences dialog This chapter is intended to inform you how to use all these options Setting general options sa These options define general behavior of Data Import for SQL Server Selecting program language 70 This page allows you t
40. ck the Add button to set correspondence between the selected fields the pair of fields appears in the list below repeat the operation for all the fields you need to be included in the import process If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fieldsls3 if needed Use the corresponded context menu item to Add Edit Drop field 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual ES Add field Bg Edit field Ei Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross X If you choose a query as the data source you also can load a SQL query froma sgl file or save the current query text to a file using the Load from File and the Save to File buttons correspondingly Use the Autofill button to set correspondence between the source and target fields automatically on the basis of their order Files Select import source COUNTRY xls v 0 Access table CUSTOMER y 121 CUSTOMER mdb Y I gt 5 JA DEPARTMENT ods y Pa DISCOUNTS odt Ed EMPLOYEE xlsx v E JOB csv Y PAYMENT xml 2p E i ene an PROJECT dbf v Ms Th MB SALES tim y Ee CITY VARCHAR 25 EE CONTACT LAST Text 20 STATE PROVINCE VARCHAR
41. d click a column to assign the column to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process If the source file and the destination SQL Server table have the same order of columns you can use the ly Auto Fill Columns mode default to set correspondence between them automatically If source file and destination SQL Server table have different order of columns but identical names you can use the L y Auto Fill by Captions mode to set the correspondence based on name s identity The number of the column which correspondence is set for are displayed at the Grid Column column You can use it for setting the fields correspondence as well If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fields l837 if needed Use the corresponded context menu item to Add Edit Drop field 33 Add field EB Edit field 3 Drop field If necessary you can choose to skip a defined number of the source file rows using the Skip lines spin edit Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server Use
42. e to set the correspondence based on name s identity The number of the column which correspondence is set for are displayed at the Grid Column column You can use it for setting the fields correspondence as well If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fields 837 if needed Use the corresponded context menu item to Add Edit Drop field 33 Add field Edit field 3 Drop field If necessary you can choose to skip a defined number of the source file rows using the Skip lines spin edit Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross X 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server User s Manual Files Ed COUNTRY xls E x k CUSTOMER mdb Fields Grid C B DEPARTMENT ods B PO NUMBER VARCHAR 8 1 3 DISCOUNTS ot CUST NO INTEGER 2 1 e Ed EMPLOYEE xlsx Y EX JOB csy v 4 ORDER STATUS VARCHAR 7 4 ke PAYMENT xml ORDER DATE TIMESTAMP 0 PROJECT dbf EG SHIP DATE TIMESTAMP 0 dEl SALES html v 8 DATE NEEDED TIMESTAMP 0 n STORES txt 8 PAID VARCHAR 1 2 CITY smi Ga QTY ORDERED INTEGER ET FILM docx zd E PO NUMBE CUST NO SALES REF ORDER_ST ORDER_DA SHIP_DATE DATE_NEEI PAID
43. e Data Import console application 14 e I work behind a firewall router Can EMS Data Import connect to a remote SOL Server sewer hA e How to connect to a named instance of SQL Server in EMS Data Import for SQL Server ha e When connecting to SQL Server I get an error SQL Server does not exist or access denied What is wrong h e I can access my server via an alternative port I have searched for a setting in EMS Data Import for SQL Server to alter the connection port but have not yet been able to locate this How would I go about altering this port 15 Question answer list Q What is EMS Data Import for SQL Server A EMS Data Import for SQL Server is a powerful tool to import your data quickly from MS Access MS Excel DBF TXT CSV XML MS Excel 2007 MS Word 2007 HTML ODF files to SQL Server tables It provides adjustable import parameters including source data formats for all the fields and destination data formats for the selected fields commit options number of records to skip etc Data Import includes a wizard which allows you to set all the import options for different files visually and a command line utility to execute import in one touch Q What do I need to start working with EMS Data Import for SQL Server A First of all you must have a possibility to connect to some local or remote SQL Server to work with Data Import You can download SQL Server from http www microsoft com downloads Besides you need
44. e error occurred When importing from several files their logs e4 are located at different tabs while the main log contains general information about these processes DBEA Wrong identification of Integer type fields Fixed now Keep identity option did not work Fixed now yyyy mm ddThh nn ss format was recognized incorrectly Fixed now HTML 451 When importing from HTML file with the links the application froze Fixed now Other improvements and bugfixes See also Version history 1999 2014 EMS Database Management Solutions Ltd EX Data Import for SQL Server User s Manual 1 2 System requirements System requirements for Data Import for SQL Server e 300 megahertz MHz processor 600 megahertz MHz or faster processor recommended e Microsoft Windows NT4 with SP4 or later Microsoft Windows 2000 Microsoft Windows 2000 Server Microsoft Windows XP Microsoft Windows 2003 Server Windows 2008 Server Microsoft Windows Vista Microsoft Windows 7 Microsoft Windows 8 Microsoft Windows 8 1 e 64MB RAM or more 128MB or more recommended e 20MB of available HD space for program installation Super VGA 800x600 or higher resolution video adapter and monitor Super VGA 1024x768 or higher resolution video adapter and monitor recommended Microsoft Mouse or compatible pointing device Microsoft Data Access Components MDAC or SQL Server Native Client Possibility to connect to any local or remote SQL
45. efault value function script left right quotation quotation action character case character set Generator value Use this field to set the initial value of the autoincrement field Generator step Set the step of the autoincrement field If it is 0 or if the field is of Identity one then the value of the generator will be ignored Constant value Use this field to set a constant value for the field Null value Set the value which will be considered as NULL to set the default value Default value Set the default value of the NULL field 1999 2014 EMS Database Management Solutions Ltd 55 Data Import for SOL Server User s Manual Files Field Field Customization Ed COUNTRY xls 8 EMP NO SMALLINT Generator value 0 e CUSTOMER mdb FIRST NAME VARCHAR 15 Generator step 0 JA DEPARTMENT ods LAST NAME VARCHAR 20 wA 2 DISCOUNTS odt 3 PHONE EXT VARCHAR 4 H EMPLOYEE xlsx HIRE DATE TIMESTAMP 0 Null value JOB csv DEPT NO VARCHAR 3 Default value 2 PAYMENT xml JOB CODE VARCHAR 5 PROJECT dbf JOB_GRADE SMALLINT daa a SALES html JOB COUNTRY VARCHAR 15 Script STORES txt B SALARY DECIMAL 10 2 eae 2 CITY xml FULL NAME VARCHAR 37 j i T FILM docx Ss aoe Quotation action None y Char case As Is y Char set As Is y Replacements Text to Find Replace With Ignore Case dh um Database DIOMED WINE Table TESTER EMPLOYE SKP this s
46. em All the options will be saved to the template file which can be used by the console application Q I work behind a firewall router Can EMS Data Import connect to a remote SQL Server server A Yes but to do this you should open the port where SQL Server works 1433 by default on your firewall and on the firewall of the remote network Q How to connect to a named instance of SQL Server in EMS Data Import for SQL Server A To connect to a named instance of SQL Server 2005 just enter instance name in after host name and back slash symbol in Host name field at the Setting Connection Properties step For example my_server my_instance To connect to a named instance of SQL Server 2000 you need Run SQL Server Client Network Utility WINDOWS SY STEM32 cliconfig exe on client computer where Data Import for SQL Server runs Go to the second Alias tab of the Utility Add a new server alias with Server Name in form lt server_name gt lt instanse_name gt and TCP IP as Network library Use the server alias name as host name in Data Import Q When connecting to SQL Server I get an error SQL Server does not exist or access denied What is wrong A Probably your SQL Server is installed as a named instance See Q How to connect to a named instance of SQL Server in EMS SQL Manager for SQL Server 141 Besides the following factors can be the reasons for connection problems You are trying to connect to SQL Serve
47. emplateFile datafile lt source file name gt B datafile Indicates the source file for data import TemplateFile Stands for the itm template file to be used as the console version execution parameter B Use this parameter in the command line to run the console version of Data Import for SQL Server in the background mode Example C Program Files EMS Data Import for SQL Server MsImportC exe C EMS DataImport Templatel1 itm B Note The following exit codes can be returned by Data Import for SQL Server to the operating system after performing the latest task 0 successful completion 1 error s occurred during task performing 2 fatal error occurred The task was not performed See also Working with wizard application 24 Configuration file format 78 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual 3 2 Configuration file format The configuration file is divided into several sections Connection This section contains parameters for connecting to the server Host Login Password encrypted These parameters are obligatory PREFERENCES This section contains the general settings of the utility ImportToViews 1 enabled 0 disabled The following sections are unique for each imported file and contain the appropriate postfix FILE 00 FILE 01 FILE 02 etc In these sections the import options for each particular file are stored FILE 00
48. et files if you need to import data from different sheets into different tables you are to include that multi sheet spreadsheet file into the list several times equal to the number of sheets to be imported to different tables When a file is selected the Select Table dialog appears O 1999 2014 EMS Database Management Solutions Ltd 2 Data Import for SQL Server User s Manual Select Table ES File name EA AAdventurewlorksProduction_Product xls Database AdventureWorks Refresh Insert into existing table Tables ES Production Document ES Production Illustration ES Production Location o Y ES Production CHEST son ES Production ProductCostHistory ES Production ProductDescription ES Production ProductDocument ES Production Productlnventory ES Production ProductListPriceHistory Create new table OK Cancel File name field displays the selected file name and its location Database field allows you to specify the target database 9 Insert into existing table Select this option to import data to the existing table Tables area contains the list of tables in the selected database You can refresh the list by clicking the Refresh button 9 Create new table Use this option to create import destination table To change the target SQL Server table that has been already assigned to a source data file select the table in the list and press the ellipsis L
49. et table fields press the ED Clear All ranges button To set a range of datalss5 to be imported from the file use the ES Add range button To remove a range use the Delete range button Using the Le Move Up and the Move Down buttons you can change the order of ranges applied to data Click the Next button to proceed to the Setting base data formats 49 step of the wizard 2 1 5 2 MS Excel 2007 Select the needed source file from the list Then specify ranges in the grid for the target and source fields e select a field of the target SQL Server table in the Fields list e proceed to the Sheet grid click a column to assign the column to the selected target 1999 2014 EMS Database Management Solutions Ltd 33 Data Import for SOL Server User s Manual table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process If the source file and the destination SQL Server table have the same order of columns you can use the 13 y Auto Fill Columns mode default to set correspondence between them automatically If source file and destination SQL Server table have different order of columns but identical names you can use the Ka Auto Fill by Captions mode to set the correspondence based on name s identity Note The number of the column for which correspondence was set is displayed at the Col control You can u
50. fault to set correspondence between them automatically If source file and destination SQL Server table have different order of columns but identical names you can use the Le f Auto Fill by Captions mode to set the correspondence based on name s identity The number of the column which correspondence is set for are displayed at the Grid Column column You can use it for setting the fields correspondence as well 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fields s3 if needed Use the corresponded context menu item to Add Edit Drop field Bg Add field S8 Edit field Bg Drop field If necessary you can choose to skip a defined number of the source file rows using the Skip lines spin edit Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross X ds Le fe X J 9 jJ Ed COUNTRY xls Y 121 CUSTOMER mdb w Fields IA DEPARTMENT ods v Ed DEPT_NO VARCHAR 3 DISCOUNTS odt Aa VARCHAR 25 Ed EMPLOYEE xlsx v j E JOB csv v Ed MNGR_NO SMALLINT 2 PAYMENT xml Ed BUDGET DECIMAL 12 2 PROJECT dbf w EB LOCATION VARCHAR 15 VE SALES html v li PHONE NO VARCHAR
51. ign explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for MySQL Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for MySQL Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for MySQL Migrate from most popular databases MySQL PostgreSQL Oracle DB2 InterBase Firebird etc to MySQL Data Generator for MySQL Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for MySQL Compare and synchronize the structure of your databases Move changes on your development database to production with ease w d es B DB Extract for MySQL Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for MySQL Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more amp Data Comparer for MySQL Compare and synchronize the contents of your databases Automate your data migrations from development to production database wA Scroll to top 16 O 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server Use
52. ing Run SQL Server Configuration Manager on client computer where Data Import runs Expand the SQL Native Client Configuration section Select the Aliases section Add a new server alias and set server name port number and TCP IP as Network library Use the server alias name as host name in Data Import utility To connect to SQL Server 2000 on alternative port do the following Run SQL Server Client Network Utility WINDOWS SYSTEM32 cliconfg exe on client computer where Data Import runs utility Go to the second Alias tab of the Utility Add a new server alias and set server name port number and TCP IP as Network library Use the server alias name as host name in Data Import utility Scroll to top 13 If you still have any questions contact us at Support Center 1999 2014 EMS Database Management Solutions Ltd 16 Data Import for SQL Server User s Manual 1 7 Other EMS Products Quick navigation W r ow MySQL T Microsoft SQL PostgreSQL InterBase Oraclel 1 IBM DB2 Tools amp 1 1 FireBird 1 209 components 21 MySQL e SQL Management Studio for MySQL EMS SQL Management Studio for MySQL is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for MySQL Simplify and automate your database development process des
53. ing scripts to execute before and after importl s Step 11 Start of data import processle4l See also Using data import configuration files 66 Setting program preferencesles 2 1 1 Getting started This is how Data Import for SQL Server wizard application looks when you first start it This page allows you to view registration information If you have not registered Data Import for SQL Server yet you can do it by pressing the Register button and entering your registration information 1999 2014 EMS Database Management Solutions Ltd 25 Data Import for SOL Server User s Manual ES Data Import for SQL Server keba Welcome to Data Import for SQL Server This Wizard helps you to import data from XLS XLSx MDB DBF TXT CSV XML DOCx HTML ODS and ODT files to SQL E Server database tables Le Click Next to start working with the wizard yan Product Information p Developers Alex Paclin Dmitry Schastlivtsev Paul Leonov SQL Server Homepage http www salmanager net products mssql dataimport Support Ticket System http www salmanager net support Version 3 7 0 build 43422 Registered to EMS Business license Enter Registration Code Help Tools E Back Close Press the Next button to proceed to Setting connection properties 25 See also How to buy Data Import ho 2 1 2 Step 1 Setting connection properties At this step you should specify necessary setti
54. lar data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for PostgreSQL Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for PostgreSQL Migrate from most popular databases MySQL SQL Server Oracle DB2 InterBase Firebird etc to PostgreSQL Data Generator for PostgreSQL Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for PostgreSQL Compare and synchronize the structure of your databases Move changes on your development database to production with ease amp d 4 B DB Extract for PostgreSQL Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for PostgreSQL Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more amp Data Comparer for PostgreSQL Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to top 5 InterBase Firebird e SQL Management Studio for InterBase Firebird EMS SQL Management Studio for InterBase and Firebird is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use en
55. ll be marked with a tick Y If an error occur during table creation this table will be marked with a cross X Click the Next button to proceed to the Setting base data formats 49 step of the wizard 2 1 5 9 CSV Set correspondence between the target table fields and the source CSV file columns e select the Delimiter and Quote characters for CSV files using the corresponding drop down lists of the CSV Parameters group e select a field of the target SQL Server table in the Fields list e proceed to the source grid viewer area click a caption to assign the column to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server User s Manual The source file character set can be defined at the Encoding field If the source file and the destination SQL Server table have the same order of columns you can use the Auto Fill Columns mode default to set correspondence between them automatically If source file and destination SQL Server table have different order of columns but identical names you can use the L8 f Auto Fill by Captions mode to set the correspondence based on name s identity When you import data to a newly created table the Analyze button appears Use this button for automatic field creation If necessary
56. mand line utility to execute import in one touch Visit our web site http www sglmanager net for details Key features e Import from most popular formats MS Excel 97 2007 MS Access XML DBF TXT CSV MS Word 2007 Open Document Format and HTML Importing data to one or several tables or views from different databases Automatically creates table structure Special batch insert commands allow to import data at the maximum possible speed A number of import modes Insert All Insert New Insert or Update and others UNICODE support Adjustable import parameters for each source file Saving all import parameters set on current wizard session Command line utility to import data using the configuration file Powerful visual options module User friendly localisable wizard interface Product information Homepage http www sglmanager net en products mssgl dataimport Support Ticket http www sglmanager net support System Register online at http www salmanager net en products mssql dataimport bu O 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual 1 1 What s new Version Release date Data Import for SOL Server 3 7 June 09 2014 What s new in EMS Data Import Import rate is increased due to use of multithreading XML 2 Added the possibility of manual and automated identification of the type of the imported XML file Now log e4 contains information about the string number where th
57. mit the transaction after all records are imported Commit after each records These control allows you to define the number of records in each block to be supplemented with the COMMIT statement Rollback on error Check this option to rollback the transaction if an error occurred Record Count 1999 2014 EMS Database Management Solutions Ltd 5 Data Import for SQL Server User s Manual 9 Import all records Specifies that all records of the source file will be imported 9 Import only record s Specifies the number of records to be imported Y Import empty rows If this option is checked then empty records are imported Y Auto trim values Check this function to remove all leading and trailing white space characters from all imported records Y Save Result SQL Script to File This option allows you to save the result SQL script of the import operation to an external sql file on your disk drive Specify the script file name and select its location using the ta button which calls the Save As dialog Files Commit Ed COUNTRY xls Commit when done CUSTOMER mdb JA DEPARTMENT ods Commit after each 1000 records E 55 DISCOUNTS odt m E E E EMPLOYEE xlsx E JOB csv Record Count 2 PAYMENT xml fa PROJECT dbf Import all records Iz E SALES html er E STORES txt 2 CITY xml WF FILM docx Auto trim values V Save result SOL sc C EMS docs COUN
58. n button If the execution fails you see the message box with the description of an occurred mistake If the execution succeeds you see the message box with the result as it is shown on the picture below o Test run succeeded Result Tchaikovsky Piotr For more information about JScript see http msdn microsoft com en us library x85xxsf4 aspx 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual Quotation Left quotation Set a character or a number of characters to denote quoting in the imported string Right quotation Set a character or a number of characters to denote unquoting in the imported string Quotation action You can select the Add item to add quotation marks to the imported string the Remove item to remove all the quotation marks from the imported string or the None item to save the original quotation marks String conversion Char case Set the case of the imported string As Is keeps the original string unchanged Upper sets the whole string to the upper case Lower sets the whole string to the lower case UpperFirst sets the first character of the string to the upper case UpperFirstWord sets the first character of each word to the upper case Char set Set the char set of the imported string to ANSI or OEM As Is saves the original character set of the string The Replacements area allows you to set the text you need to be replaced during data
59. n them automatically The source file character set can be defined at the Encoding field V Autoscroll This option scrolls the document automatically when you switch to the next field for mapping When you import data to a newly created table the Analyze button appears Use this button for automatic field creation 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server User s Manual Fies L Jx J J ET COUNTRY xls 121 CUSTOMER mdb JA DEPARTMENT ods DISCOUNTS odt Ed EMPLOYEE xlsx E JOB csv 2 PAYMENT xml PROJECT dbf E SALES html I STORES txt 2 CITY xml New fields Pos Le Eg STOR NAME VARCHAR 39 4 39 Fneedng Windows default las ES STOR ADDRESS VARCHAR 43 22 V Auto scroll ES CITY VARCHAR 32 65 32 ES ST ZIP VARCHAR 19 97 19 EX XX S44 STOR ADDRESS 788 Catamaugus Ave 567 Pasadena Ave 577 First St 24 A Avogadro Way 89 Madison St 679 Carson St Database DIOMED New table TESTER STORES Double click in the text viewer area to add remove vertical separator To remove all correspondences press the X Clear All Ranges button If you choose to import data to the newly created table at this step you need to create necessary fields Use the corresponded context menu item to manage fields s3 Bj Add field ES Edit field 3 Drop field Note If table was properly created or already exist it wi
60. nage fields s3 Sj Add field 33 Edit field Bi Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occurs during table creation this table will be marked with a cross X 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server User s Manual Click the Next button to proceed to the Setting base data formatsl491 step of the wizard 2 1 5 8 TXT Set correspondence between the source text file columns and the target SQL Server table fields e select a field of the target SQL Server table in the Fields list e double click in the text viewer area to add vertical separators delimiting the source column bounds e click the area between the separators to assign the column to the selected target table field the selected source column gets black highlight e repeat the operation for all the fields you need to be included in the import process The Fields list also allows you to view the following values P represents the starting point of your selection S displays the width of the selected area You can change these parameters manually or by moving the slider in the grid If necessary you can choose to skip a defined number of the source file lines using the Skip lines spin edit If the source text file and the destination SQL Server table have the same order of columns you can use the 9 Autofill Columns button to set correspondence betwee
61. nd new records are inserted into the destination table Delete already existing records are deleted Delete or insert existing records are deleted and new records are inserted into the destination table Here is an example of some import modes offered by Data Import utility DB Table Source file 21D DATA All import modes except for the Insert All mode are based on primary key values information In order to perform import operations with these modes used you need to have matches between the source file primary key column s and the destination table primary key column s Insert Insert all Insert new Update mode Result 1D v DATA 3 1D y DATA y 21D w DATA e gt meds H EN at E zA m el mm 2 b 3e alt 21d alt 3le alt O 1999 2014 EMS Database Management Solutions Ltd s Data Import for SQL Server User s Manual Insert Update or insert Delete Delete or insert mode Result 210 v DATA v 21D DATA x ZID w DATA v joe 1 mm DATA e Fue WA cR oo 3 e alt It is applied to all other import modes except for the Insert all mode For all these modes except for the Insert all mode it is obligatory to select the primary key fields This field or fields is used as key field to identify specific data in the target database The key columns for these operations are defined at the Selecting key columns 601 step of the wizard
62. ngs to establish connection to the target SQL Server database Connection settings For connection you should enter SQL Server host name in the Host field or select the needed host from the drop down list This list is formed using SQL DMO components function ListAvailableSQLServers If SQL DMO components are not installed the NetServerEnum function from netapi32 dllis used If neither SQL DMO components nor netapi32 dll are installed the Host drop down list will be empty when the program is launched for the first time and filled with host names already registered in the program during further launches Please note that if Microsoft SQL Server is installed as a named instance you should specify Remote as the connection type and enter the name or IP address of your O 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server User s Manual machine and the instance name in the Host field in the following format computer_name sqlserver_instance_name or ip_address sqlserver_instance_name e g MY COMPUTER SQLEXPRESS 127 0 0 1 SQLEXPRESS Authentication Type Specify the type of SQL Server authentication to be used for the connection SQL Server or Windows authentication It is strongly recommended to avoid using SQL Server authentication with sa as the login If SQL Server has been selected as the authentication type you should also provide authorization settings Login and Password
63. nt Solutions Ltd e Data Import for SQL Server User s Manual When you are done press the Next button to proceed to the last step e4 2 1 12 Step 11 Start of data import process This step of the wizard is intended to inform you that all import options have been set and you can start the import process If everything is correct press the Import button to start the process If you want to change something you can return to any of the wizard steps using the Back button Y Continue if before import es script is executed with errors Check this option to ignore errors in Before Script execution during import Y Close progress when done If this option is selected the child window indicating the import progress is closed automatically when the import process is completed Parallel execution Check this option to perform several files import process simultaneously Data Import for SQL Server co Step 11 of 11 Click the Import button to start data import process Si Continue if before import script is executed with errors a Close progress when done Parallel execution Si grs Import Started Data 13 18 02 842 Import file CXEMS Data Export for SQL Server HumanResources_Department html finished Import 13 18 03 270 Import file CXEMS Data Export for SOL Server HumanResources_Employee xls finished tor 13 18 03 393 Import file C XEMS Data Export for SOL Server HumanResources_Empl
64. o select a language to be applied for your copy of Data Import for SQL Server Setting data font 71 Allows you to adjust font settings for the data displayed in the application Setting Excel options 72 Allows you to adjust Excel data representation settings Defining interface style 73 This branch contains several pages with a number of options allowing you to customize the application interface style according to your liking z gt Load Template HQ Preferences Reopen Template See also Working with wizard application 24 Using data import configuration files 66 2 3 1 General General Y Confirmation on exit Enables disables confirmation upon exiting the program VI Skip intermediate steps This option determines the behavior of the Next and Back buttons When this option is disabled clicking the Next button leads to sequential passing through the list of imported objects When this option is enabled the steps checked in the Skipped steps group will O 1999 2014 EMS Database Management Solutions Ltd e Data Import for SQL Server User s Manual be skipped Key columns reminder Use this option to enable disable prompts to define key columns Languages Data Font Excel Options Interface Confirmation on exit Skip intermediate steps Key columns reminder Remember password Show field types Show number of created tables Show number of mapped columns Use first row as c
65. oc ODS ODT The open file dialog allows you to set a filter on the source file format If you have selected the file of a format that is not supported the Select Import Type dialog appears Select Import Type a File name C EMS docs film dbt Import Type i MS Excel 2007 MS Access MS Word 2007 DBF HTML TXT XML Document CSV ODS XML ODT Associate Extension OK Cancel Here you can select which import type for supported file formats should be applied to import the selected file To delete a file from the list select it and click the i Remove File button 1999 2014 EMS Database Management Solutions Ltd 2 Data Import for SOL Server User s Manual You can also change the order of the source files in the list using the Up e and the Down buttons p Add file g Remove file e Le File Table BI C EMS docs COUNTRY xls DEMODB HumanResources COUNTRY 21 C EMS docs CUSTOMER mdb DEMODB HumanResources CUSTOMER E C EMS docs DEPARTMENT ods DEMODB HumanResources DEPARTMENT E C EMS docs DISCOUNTS odt DEMODB HumanResources DISCOUNTS Ba C EMS docs EMPLOYEE xlsx DEMODB HumanResources EMPLOYEE PU C EMS docs JOB csv DEMODB HumanResources JOB 2 C EMS docs PAYMENT xml DEMODB HumanResources PAYMENT DEMODB HumanResources PRODUCT 2 CAEMSAdocsiPROJECT dbf DEMODB HumanResources PROJECT Note For the spreadshe
66. olumn v Identity This option specifies that the new column is an identity column i Not for replication This option allows you to specify that the Identity property should not be enabled when a replication agent modifies the table that contains the identity column 1999 2014 EMS Database Management Solutions Ltd ss Data Import for SOL Server User s Manual 4 3 Add Edit Range To set a range of datal85 to be imported from the file use the Add range L button To remove a range use the Delete range an button To edit an existing range double click it in the Ranges list The Range dialog allows you to set a number of options for the range being edited Range PIE Range Type TS Col A x Start Finish From Data Starting While Data Exists Start Row 1 Finish Row Direction Down Up Sheet Default Sheet Custom Sheet Sheet Number 9 Sheet Name Sheet 1 Cancel Select Range Type from the corresponding drop down list Then specify the column row or cell number whose range is to be defined Start and Finish section allows you to set the range of the values to be imported from the specified row or column Use the From Data Starting and While Data Exist options to automatically define the range of the values If neither start row column nor finish row column was specified you need to set range direction Down or 9 Up for column range and Right or 9 Left for row range Use
67. oyeeAddress ods finished SAL Server 3 Files Import process finished Log Log3 Log2 Logt Save log to file Clear log mala Save log to file This button calls the Save file dialog which allows you to save the on screen log to a file Clear log 1999 2014 EMS Database Management Solutions Ltd e Data Import for SQL Server User s Manual Pressing this button clears the on screen log area removing all messages If necessary you can save a templatele for future use Click the Finish button to start the import process 1999 2014 EMS Database Management Solutions Ltd e Data Import for SOL Server User s Manual 2 2 Using data import configuration files Data Import for SQL Server allows you to store its configuration settings in external itm template files if you need to perform the data import process repeatedly You can load previously saved configuration settings to the application wizard 23l if you need to make some changes before data comparison or you can run it with the console application 76 for quicker data import Data Import templates are saved loaded within the Save template options Load template dialog To open this dialog press the Tools button and select the Save template Load template popup menu item J Save Template File name When saving template specify the template file name and select its location using the ta
68. p 8 Selecting key columns This step of the wizard allows you to select the fields of the table to be used as the key fields for the import process This step is not available if the Insert all option has been selected on the previous step 581 To select a field you need to move it from the Available Columns list to the Selected Columns list Use the gt gt gt LE lt lt buttons or drag and drop operations to move the fields from one list to another O 1999 2014 EMS Database Management Solutions Ltd st Data Import for SQL Server User s Manual Files Available columns Selected columns EP COUNTRY xls Ed FIRST NAME E EMP NO CUSTOMER mdb Ed LAST NAME JA DEPARTMENT ods PHONE EXT DISCOUNTS odt Ed HIRE DATE E EMPLOYEE xlsx EX DEPT NO E JOB csv ES J0B_CODE El PAYMENT xml Ed JOB GRADE PROJECT dbf JOB COUNTRY E SALES html SALARY 531 STORES txt Ed FULL_NAME P CITY xml Wl FILM docx Database DIOMED Table TESTER EMPLOY ILS this step Skip this step Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generalls8 section of the Preferences 68 dialog When you are done press the Next button to proceed to the next steplen 2 1 10 Step 9 Setting common options Using this step of the wizard you can set final import options Commit Commit when done Check this option to com
69. port procedure will be created automatically You can manage destination table fields s3l if needed Use the corresponded context menu item to Add Edit Drop field Bg Add field Edit field 3 Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross X If necessary you can choose to skip a defined number of the source file columns and or rows using the Col s and Row s spin edits 1999 2014 EMS Database Management Solutions Ltd 32 Data Import for SOL Server User s Manual Files u a ES COUNTRY xls v ER x I r3 8 Ba 121 CUSTOMER mdb w Beds BS er JA DEPARTMENT ods v COUNTRY VARCHAR 15 Sheet 1 B COLFINISH DISCOUNTS odt esc EF EMPLOYEE xlsx y FLAG BLOB 1 EX JOB csv Y 9 PAYMENT xml Ii PRODUCT docx PROJECT dbf Y E SALES html v FS STORES t t CITY Skip row s 1 Skip col s 0 Sheet 1 A d 1 D E F G H E 1 COUNTRY CURRENCY 2 USA Dollar 3 England Pound 4 Canada CdnDir 5 Switzerland SFranc L B Japan Yen Database DIOMED 7 Itali lira m Table TESTER COUNTE y If your spreadsheet file contains several sheets you are able to set different mapping for each sheet To clear ranges for a field select the field in the Fields list and press the X Clear Field Ranges button To clear all ranges specified for the targ
70. r beyond your local network through firewall See Q I work behind a firewall router Can Data Import connect to a remote SQL Server hA Wrong login password Either you use SQL Server Authentication but this authentication type is forbidden on the server or you use Windows Authentication to connect to the server but the login that corresponds to your domain name is absent on SQL Server MDAC works incorrectly Try to reinstall Microsoft Data Access Components SQL Server works on a non standard other than 1433 port See Q I can access O 1999 2014 EMS Database Management Solutions Ltd 15 Data Import for SOL Server User s Manual my server via an alternative port I have searched for a setting in the program to alter the connection port but have not yet been able to locate this How would I go about altering this port 151 There are no enabled client connection protocols Or all enabled client connection protocols are disabled on server side Use SQL Server Client Network Utility WINDOWS SYSTEM32 cliconfig exe for connection to SQL Server 2000 or lower or SQL Server Configuration Manager to enable appropriate protocols Q Ican access my server via an alternative port I have searched for a setting in EMS Data Import for SQL Server to alter the connection port but have not yet been able to locate this How would I go about altering this port A To connect to SQL Server 2005 on alternative port do the follow
71. r s Manual Fies L Js X JU jJ COUNTRY xls v 21 CUSTOMER mdb w New fields Grid Column JA DEPARTMENT ods v 3B DISCOUNTTYPE VARCHAR 17 B A DISCDUNTS odt 4 STOR ID VARCHAR 10 B EMPLOYEE xlsx v 4 LOWQTY VARCHAR 10 c Fah JOB csv w E HIGHQTY VARCHAR 10 D 4 PAYMENT xml i DISCOUNT DOUBLE E PROJECT dbf v E SALES html v STORES txt 4 CITY xml SAA 41 FILM docx Skip line s 1 E DISCOUNTTYPE 5 jLOWQTY HIGHQTY DISCOUNT E Initial Customer null null null 10 50 Volume Discount null 100 1 000 5 70 Customer Discount 8042 null null 5 00 Database DIOMED New table TESTER DISCOUN To remove a correspondence select the field in the Fields list and press the x Clear Field Ranges button To remove all correspondences press the e Clear All Ranges button If your OpenDocument Text file contains several tables you are able to set different mapping for each table Click the Next button to proceed to the Setting base data formats 9 step of the wizard 2 1 6 Step 5 Setting base data formats This step of the wizard provides a number of options for setting base formats for each source data file The specified format should match the source data representation O 1999 2014 EMS Database Management Solutions Ltd so Data Import for SQL Server User s Manual Files Separators Constants EH COUNTRY xls Decimal Boolean true True CUSTOMER mdb
72. r s Manual Microsoft SOL ES fa o dd B e D amp SQL Management Studio for SQL Server EMS SQL Management Studio for SQL Server is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before EMS SQL Backup for SQL Server Perform backup and restore log shipping and many other regular maintenance tasks on the whole set of SQL Servers in your company SQL Administrator for SQL Server Perform administrative tasks in the fastest easiest and most efficient way Manage maintenance tasks monitor their performance schedule frequency and the last execution result SQL Manager for SQL Server Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for SQL Server Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for SQL Server Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for SQL Server Migrate from most popular databases MySQL PostgreSQL Oracle DB2 InterBase Firebird etc to Microsoft SQL Server Data Generator for SOL Server Generate test
73. remain the same the next time the program is started Vi Allow script execution If this option is checked then the script entered on the Step 5 s4lis always executed Wi Show databases This option enables disables the Select Database drop down list in Select Table dialog at Step 2 27 of the wizard If you check this option you can select the database from the list otherwise you must type the database name manually v Exclude autoincrement fields If this option is checked then autoincrement fields will not be mapped on auto mappingls0 Skipped Steps Use this option group to define the Wizard application 23 steps to be skipped See also Selecting program language 70 Setting data font 7 Setting Excel options 72 Defining interface style 72 Languages The Languages page is provided for managing Data Import localization files You can create your own Ing files similar to those available in the Yoprogram directory Yo Languages folder add them to the list of available languages and set the new language as the program interface language The table lists all the languages available for localization and the corresponding ng files 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual 2 3 3 v General L y Languages anguages Data Font a Excel Options None Interface i C Program Files EMS D ata Import for SOL ServerLanguages english C Program Files EMS D
74. result files are fully compatible with Microsoft 9 Excel versions 97 2000 2003 and XP MS Access File of Microsoft Access format mdb with an ADO connection used o HTML Hyper Text Markup Language file format html htm complete compatibility with HTML 4 0 specification Text file Plain text file format txt o CSV file Comma Separated Value file format csv Note all the text formats including Text file CSV are usually used as working or interchange formats 9 XML A markup language for documents containing structured information xm I 9 DBF Database file format dbf used by dBASE and a number of xBASE applications 9 MS Excel 2007 The contemporary e table format used by Microsoft Excel 2007 xlsx The result files are fully compatible with Microsoft Excel 2007 9 MS Word 2007 The contemporary text processing format used by Microsoft Word 2007 docx The result files are fully compatible with Microsoft Word 2007 9 ODF Spreadsheets OASIS Open Document Format for Office Applications open document file format for spreadsheets ods used by a number of applications including OpenOffice org and KOffice ODF Text OASIS Open Document Format for Office Applications open document file format for word processing odt documents used by a number of applications including OpenOffice org and KOffice 1999 2014 EMS Database Management Solutions Ltd es
75. rsion which is implemented in the form of a wizard application the installation package of Data Import for SQL Server includes the console version which is intended for being run from Windows command line with a template file name used as the execution parameter C Program Files EMS Data Import for Data Import for SQL Server command line utility is intended for quick and powerful data import to SQL Server tables Working with console application 77 Configuration file format 78 See also Wizard Application 23 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual 3 4 Working with console application All the import options are set in template itm files A template can be also used in the Console version of Data Import for SQL Server To create a template file follow the instructions below e start Data Import Application wizard 23 e set all the required options in all steps of the wizard e test the import process at the last step e save all import options in the templatel e Console application also generates the og file that contains information about the import operation completion The easiest way to start Data Import for SQL Server console application is to double click the generated itm template The other way is to enter the command line and type the appropriate command Usage lt path to Data Import for SQL Server console application gt MsImportC exe T
76. s the period era as an abbreviation Japanese and Taiwanese locales only gg Displays the period era as a full name Japanese and Taiwanese locales only m Displays the month as a number without a leading zero 1 12 If the m specifier immediately follows an h or hh specifier the minute rather than the month is displayed mm Displays the month as a number with a leading zero 01 12 If the mm specifier immediately follows an h or hh specifier the minute rather than the month is displayed mmm Displays the month as an abbreviation Jan Dec using the strings given of the Short Month Names mmmm Displays the month as a full name January December using the strings of the Long Month Names 1999 2014 EMS Database Management Solutions Ltd 53 Data Import for SOL Server User s Manual yy Displays the year as a two digit number 00 99 vyyy Displays the year as a four digit number 0000 9999 h Displays the hour without a leading zero 0 23 hh Displays the hour with a leading zero 00 23 n Displays the minute without a leading zero 0 59 nn Displays the minute with a leading zero 00 59 s Displays the second without a leading zero 0 59 ss Displays the second with a leading zero 00 59 Z Displays the millisecond without a leading zero 0 999 ZZZ Displays the millisecond with a leading zero 000 999 t Displays the time using the Short Time Format tt Displays the time using
77. se it for setting the fields correspondence as well If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fields s3l if needed Use the corresponded context menu item to Add Edit Drop field EH Add field Edit field 3 Drop field If necessary you can choose to skip a defined number of the source file rows or columns using the Skip lines or Skip cols spin edit Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross X 1999 2014 EMS Database Management Solutions Ltd ss Data Import for SQL Server User s Manual 5 462006 E Ed COUNTRY xls v 121 CUSTOMER mdb w Fields Ranges JA DEPARTMENT ods w EG EMP NO SMALLINT Ei sheet1 C1 COLFINISH gt DISCOUNTS odt FIRST NAME VARCHAR 15 EP EMPLOYEE xlsx w F9 LAST NAME VARCHAR 20 El Ed JOB csv Y 38 PHONE EXT VARCHAR 4 2 PAYMENT xml 48 HIRE DATE TIMESTAMP 0 W PRODUCT docx DEPT_NO VARCHAR 3 E PROJECT dbf JOB CODE VARCHAR S E SALES html v JOB_GRADE SMALLINT STORES txt 4 amp JOB COUNTRY VARCHAR 1S 2 CITY xml Skip row s 0 Skip col s 0 2 FIRST_NAN LAST NAMI PHONE EX HIRE DATE DEPT NO JOB CODE JOB Robert Nelson 250 0 00 00 600 VP 2 Bruce Young 233
78. stination table fields is set 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual If the source file is an Excel file then the map is set in the following format lt DB_FieldName gt CellIndex Use semicolon to separate multiple cells You can define an Excel row or column as a range of cells e g Fieldi A1 A4 A6 A9 B1i F1 If the source file is an Access or DBF file then the mapping is set in the following format lt DB_FieldName gt lt Source_Field_Name gt If the source file is a TXT file the mapping looks in the following way lt DB_FieldName gt lt Position gt lt Size gt This means that you should provide the starting position and the size of the source file column for each destination field To set mapping for a CSV file provide a column number for each destination field e g Field1 1 Field2 4 etc The properties that are set in sections FILE_XX_BASE_FORMATS and FILE XX IMPORT OPTIONS correspond to those set on the Base Formats and the Options tabs The values that stand for BOOLEAN TRUE and BOOLEAN FALSE values are set in sections FILE XX BOOLEAN TRUE and FILE XX BOOLEAN FALSE The NULL values are set in section FILE KK NULL VALUES Data formats that are set for each destination field separately are stored in sections named in the following way FILE XX DATA FORMATS FIELD NAME e g FILE 00 DATA FORMATS FIELDI The properties within
79. t for SQL Server wizard application provides easy to use wizard interface to set all data import parameters visually Working with wizard application 24 Using configuration files 6e Setting program preferences 68 This Wizard helps you to import data from XLS XLSx MDB DBF TXT CSV XML DOCx HTML ODS and ODT files to SOL Server database tables ES Dor Click Next to start working with the wizard Data Product Information pot Developers Alex Paclin Dmitry Schastlivtsev Paul Leonov SQL Server Homepage http www salmanager net products mssql dataimport Support Ticket System http www salmanager net support Version 3 7 0 build 43422 Registered to EMS Business license Enter Registration Code See also Console Application 7 1999 2014 EMS Database Management Solutions Ltd 24 Data Import for SQL Server User s Manual 2 4 Working with wizard application Follow the steps of the wizard to import data to SQL Server tables for your needs Getting started 24 Step 1 Setting connection properties 25 Step 2 Selecting files to import hA Step 3 Setting XML file typel 29 Step 4 Mapping fields 3o Step 5 Setting base data formats 49 Step 6 Setting data formats for each field s4 Step 7 Specifying import modelss Step 8 Selecting key columns to exclude from import process 60 Step 9 Setting commit options er Step 10 Defin
80. tep Function Use the drop down list to select one of the function return values that can be set in the field Date Time Date amp Time Long File Name Short File Name Script Press the button to add edit the script in the Script Editor 1999 2014 EMS Database Management Solutions Ltd s Data Import for SOL Server User s Manual NAME Piotr Tchaikovsky The result of script execution corresponds to the value of the last variable The example shows how you can get field value convert it to a number incremented by the number value of the current month To run the example input Field Value For Testing in text editor and uncomment the folloving three lines R amp NAME var D new Date k parseInt R D getMonth var re pattern w s w var input string SNAME result input string replace re pattern 2 1 4 17 53 Insert cancel Use the Script Editor window to enter the script for the field processing Here you can use all features of the MS JScript The picture above shows the example of the Jscript use for the field Name processing The entered code converts the XXXX YYYY string to the YYYY XXXX one for example Piotr Tchaikovsky gt Tchaikovsky Piotr If you want to test your code and see the result of its execution then enter the test field value in the Field Value For Testing box and click the Test Ru
81. ters d DB Comparer for Oracle Compare and synchronize the structure of your databases Move changes on your development database to production with ease amp DB Extract for Oracle Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for Oracle Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more i amp Data Comparer for Oracle Compare and synchronize the contents of your databases Automate your data migrations from development to production database cl Scroll to top 165 DB2 SQL Management Studio for DB2 EMS SQL Management Studio for DB2 is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for DB2 Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for DB2 Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for DB2 Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface
82. these sections also correspond to the properties set on the Data Formats tab of the Settings data formats s4 step for each field FILE 00 IMPORT OPTIONS This section contains parameters that define import options specified on Steps 6 9 of the wizard CommitAfterDone 1 enabled 0 disabled CommitRecCount The number of records in each block to be supplemented with the COMMIT statement ImportRecCount 1 enabled 0 disabled Im portAllRows 1 enabled 0 disabled SaveResultSQL 1999 2014 EMS Database Management Solutions Ltd s Data Import for SQL Server User s Manual 1 enabled 0 disabled ResultSQLFile The path to the result sql file Im portKind 0 Universal Mode 1 Native Mode TruncateLongString 1 enabled 0 disabled RollbackIfError 1 enabled 0 disabled ImportMode 0 Insert All 1 Insert New 2 Update 3 Update or Insert 4 Delete 5 Delete or Insert ImportAddType 1 enabled 0 disabled Allow Duplicates 1 enabled 0 disabled NativeModeKind 0 Single Commands 1 Batch insert General This section stores information about the product name and its major version See also Working with console application 77 1999 2014 EMS Database Management Solutions Ltd ez Data Import for SQL Server User s Manual 4 Appendix 4 1 Supported file formats MS Excel The most popular e table format used by Microsoft Excel xls The
83. tion and makes online ordering by credit debit card quick and safe The following information about share it is provided for your convenience Share it is a global e commerce provider for software and shareware sales via the Internet Share it accepts payments in US Dollars Euros Pounds Sterling Japanese Yen Australian Dollars Canadian Dollars or Swiss Franks by Credit Card Visa MasterCard EuroCard American Express Diners Club Bank Wire Transfer Check or Cash If you have ordered EMS software online and would like to review your order information or if you have questions about ordering payments or shipping procedures please visit our Customer Care Center provided by Share it Please note that all of our products are delivered via ESD Electronic Software Delivery only After purchase you will be able to immediately download the registration keys or passwords and download links for archives of full versions Also you will receive a copy of registration keys or passwords by e mail Please make sure to enter a valid e mail address in your order If you have not received the keys within 2 hours please contact us at sales sglmanager net To obtain MORE INFORMATION on this product visit us at http sglmanager net en products mssql dataimport Product distribution EMS Data Import for SQL Server Business license 1 Year Maintenance EMS Data Import for SQL Server Business license 2 Year Maintenance EMS Data Import
84. umn to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process If the source file and the destination SQL Server table have the same order of columns you can use the ia ly Auto Fill Columns mode default to set correspondence between them automatically If source file and destination SQL Server table have different order of columns but identical names you can use the L8 Auto Fill by Captions mode to set the correspondence based on name s identity The number of the column which correspondence is set for are displayed at the Grid Column column You can use it for setting the fields correspondence as well If new table creation was selected at the previous stepl 27l then fields needed for the import procedure will be created automatically You can manage destination table fields s3 if needed Use the corresponded context menu item to Add Edit Drop field 5 Add field Edit field 3 Drop field If necessary you can choose to skip a defined number of the source file rows using the Skip lines spin edit Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross X 1999 2014 EMS Database Management Solutions Ltd Data Import for SOL Server User s Manual
85. vironment that will make you more productive than ever before ER SOL Manager for InterBase Firebird Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways O 1999 2014 EMS Database Management Solutions Ltd to Data Import for SQL Server User s Manual 5 Data Export for InterBase Firebird Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Ca Data Import for InterBase Firebird Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for InterBase Firebird Migrate from most popular databases MySQL SQL Server Oracle DB2 PostgreSQL etc to InterBase Firebird ES Data Generator for InterBase Firebird Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters sz DB Comparer for InterBase Firebird lt Compare and synchronize the structure of your databases Move changes on your development database to production with ease 3 DB Extract for InterBase Firebird Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for InterBase Firebird Analyze and retrieve your data build your queries visuall
86. web publication You can export data into MS Access MS Excel MS Word RTF PDF TXT DBF CSV and more There will be no need to waste your time on tiresome data conversion Advanced Data Export will do the task quickly and will give the result in the desired format Advanced Data Import Component Suite for Delphi and C Builder will allow you to import your data to the database from files in the most popular data formats e Advanced Data Import 1 12 Advanced PDF Generator f Advanced PDF Generator for Delphi gives you an opportunity to create PDF documents with your applications written on Delphi or C Builder Advanced Query Builder Advanced Builder is a powerful component suite for Borland Delphi and C Builder intended for visual building SQL statements for the SELECT INSERT UPDATE and DELETE clauses Advanced Excel Report for Delphi is a powerful band oriented generator of template based reports in MS Excel gt Advanced Excel Report Advanced Localizer Advanced Localizer is an indispensable component suite for Delphi for adding multilingual support to your applications Source Rescuer mba EMS Source Rescuer is an easy to use wizard application for Borland Delphi and C Builder which can help you to restore your lost source code Scroll to tope 1999 2014 EMS Database Management Solutions Ltd 23 Data Import for SOL Server User s Manual 2 Wizard application Data Impor
87. y work with query plans build charts based on retrieved data quickly and more E Data Comparer for InterBase Firebird Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to toph Oracle e SQL Management Studio for Oracle EMS SQL Management Studio for Oracle is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before d SQL Manager for Oracle Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for Oracle Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for Oracle Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for Oracle Migrate from most popular databases MySQL PostgreSQL MySQL DB2 InterBase Firebird 1999 2014 EMS Database Management Solutions Ltd Data Import for SQL Server User s Manual etc to Oracle Data Generator for Oracle Generate test data for database testing purposes in a simple and direct way Wide range of data generation parame
88. your workstation to satisfy the system requirements 8 for Data Import for SQL Server Q What is the difference between the Import feature of SQL Manager for SQL Server and the Data Import for SQL Server utility A First of all Data Import for SQL Server works faster as it is a considerably lighter application Besides it provides additional features for query building namely e import data to several tables simultaneously e import data to tables selected from different databases e the command line version of the utility to import data using the configuration template file with all import settings automatically creates table structure 1999 2014 EMS Database Management Solutions Ltd ta Data Import for SQL Server User s Manual Q Are there any limitations implied in the trial version as compared with the full one A Actually the trial version of the utility only allows you to import 20 of records into each table With this limitation you can test all the features implemented in Data Import for SQL Server within the 30 day trial period Note There is a 100 records instead of 20 limitation when importing from CSV TXT or MS Access files Q What is the easiest way to configure the template files for the Data Import console application A You can configure the template files for each table visually using the Data Import Wizard application Set the required options and select the Tools Save Template menu it

Data Import for SQL Server

Contents

Download Pdf Manuals

Related Search

Related Contents