Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Performing a raw data dump

Performing a raw data dump 5 years 3 months ago #2147

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.

Re:Performing a raw data dump 5 years 3 months ago #2148

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.073 seconds