Save the connection for using again later by clicking onto Connect and Create Library Connection, this will first open a window where you need to select the database and table to connect to.Ĭlicking OK will then open the window where you can specify the name for your connection. You can specify additional connection properties by opening the Additional Connection Properties tab. SQL01\SQLEXPRESS or you can also specify the TCP protocol and port i.e. To connect to an existing SQL table click onto the target window to open the connection window and go to SQL Database and select the relevant connection type.įor most SQL Servers using the SQL Client provider will be sufficient, but for details on the other providers please see our documentation here.Įnter in the network name of your SQL Server to the Server Name field. If you would like more control over how the table is created then checkout our blog on the SQL Script Generator. Your SQl table will then be created and ready to sync data to. The table name needs to be unique and not exist in your database already. Select the database to create the table in from the drop down menu and enter in a name for your table. Start by entering the network name of your SQL server and enter in any credentials needed to connect, then click Next to select your database and configure your new table. Then follow through the wizard to connect to your SQL database. To create a new SQL table you can go to Tools > Create SQL Table. The new SQL table columns will be created based upon what is included in the schema map. Make sure to include a key column that can be used to uniquely identify each record. You can do this either by dragging and dropping the CSV from the file explorer, or by clicking onto Connect Datasource > Text Files > CSV File and then browsing for your CSV by clicking onto the ellipsis in the FileName field.īefore creating the new SQL table you need to add the columns you want to include and create in the table to the schema map.īy default all the columns will be added but you can remove and re-order the columns as you need to. Start by opening Data Sync and connecting to your CSV file. If you do not have Data Synchronisation Studio you can get a free evaluation edition. Access to a SQL Server or SQL Express instance.Downloaded
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |