Performing a raw data dump

Hi,

I am looking to see if FlowHeater would help solve a database issue. We will be performing a raw data dump from a SQL server and importing into a different SQL server. The data would include things like grades, shot records, and other student data. If the exported data was in excel or xml format, could we use FlowHeater to automatically import the data into another SQL database on a scheduled time? For example, export at midnight and import an hour later automatically. How difficult would this be to setup?

Thank you for your time.
Noel
Request via Email

Hi Noel

For e few of tables this is very easy. For a whole database with hundreds of tables could be this plan a hard work. FlowHeater was not designed to dump a complete database but it´s possible.

NOTE: You can Export and Import from/to SQL Server or other destinations in just one step!

You have to create for each table a separate FlowHeater Definition. Choose on both sides (READ/WRITE) the same table on different SQL Servers and connect the field with the "auto connect" button. Try a test and save the definition. Do this for each other table you want to import/export.

Then create a CMD script file like this.

@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files\FlowHeater V2\BIN\FHBatch.exe"

%FHBATCH% C:\Your_Folder\table1.fhd
%FHBATCH% C:\Your_Folder\table2.fhd
%FHBATCH% C:\Your_Folder\table3.fhd
REM … and so on …

You have to use the correct relation order by yourself. This script you can run automatically with the help of the Windows task planer. Please have a look to following example. Automated batch CSV import into MS Access

If you want to import SQL Server auto increment values please have a look to the following support forum entry. SQL Server - set identity_insert on