Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Performing a raw data dump

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
12 years 6 months ago #2147 by FlowHeater-Team
Performing a raw data dump was created by FlowHeater-Team
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.

Please Log in to join the conversation.

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
12 years 6 months ago - 4 months 2 weeks ago #2148 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Performing a raw data dump
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.
Last edit: 4 months 2 weeks ago by FlowHeater-Team.

Please Log in to join the conversation.

Time to create page: 0.281 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.