I'm using C++ Builder (or Delphi 2007 and XE2) using DBExpress. I connected two databases one for firebird(my local hard disk) one for MySQL(on Web) using TSQLConnection. Then, my question is ... how can i use(make) SQL statement(or anything) to copy one table in Firebird into another table in MySQL? any comment will be very appreciate.. thanks a lot in advance..
How to copy a database's table to another database's corresponding one using TSQLConnection/dbExpress?
2.6k views Asked by R.O.K. At
1
There are 1 answers
Related Questions in DELPHI
- How can I read the header of request to webserver
- Receiving Notifications for Individual Task Completion OmniThreadLibrary Parallel.ForEach
- Delphi - How to get result of function from QuickReport without viewing a report?
- Out of memory while adding documents to a Firebird BLOB field with Delphi
- How to MakeScreenshot fullpage on Delphi
- How to program a COM object with an IEnumerator, IEnumerable interface inside
- How to Dynamically Add Controls to Delphi Form
- How to write a string in Stringrid with DelimitedText in FMX Delphi 11
- TGrid/TStringGrid multi cell selection / multi editing in delphi firemonkey (12)
- How to localize "Today" in the Delphi TMonthCalendar?
- How can I call a SOAP webserver method in Vue.js?
- Efficiently Handling Large Number of API Calls with Delphi 10.4 and OmniThreadLibrary
- Delphi can not compile the unit create by its "XML Data Binding Wizard"
- Save Form Properties in File and then restore those Properties after reopening
- Is it possible to open a blob without saving it to file
Related Questions in C++BUILDER
- Start a program from System32 in C++ Builder 11
- how to set c++ if...else statement for user input?
- How to close a C++ VCL form and open another one on a button click?
- How to build a Windows 64-bit platform static library (.lib) using C++ Builder 11 instead of .a file?
- How do I use .lib to compile and link in c++ builder 11.3 windows 64bits platform?
- How to create a trackbar without background or with a transparent background?
- How to create an inline keyboard with multiple rows in telegrambot using sgcWebSockets api telegram?
- How to handle an error when loading a picture into a TImage component?
- Why Does a Program Compile and Run Successfully But Then Fail to Compile and Link?
- How to detect a Stack Overflow error in C++Builder 2010?
- Getting errors "Class TButton not found" and "Error reading Image6.OnClick : Invalid Property Value" when building an old project in a newer IDE
- How to create a TMemoryStream and next LoadFromStream into a TRichEdit with proper formatting
- Adding multi language support in C++ Builder project
- Gmail users.settings REST API odd behavior
- unexpected binary tree result
Related Questions in DBEXPRESS
- livebinding TMemo with two fields from TClientDataSet (dbExpress)
- ODBC w/Firedac and dbExpress Delphi Alexandria 11.3
- How to send several insert statements using TSQLConnection.Execute
- Why is TDBGrid not showing any data and columns editor doesn't offer to add all fields?
- Update of a VCL TClientDataSet (detail set) when its master data set is empty
- Delphi: is DBexpress faster than Firedac
- SQL Query to calculates 'reserved' inventory items
- Delphi register a dbexpress dll (dbexpsda40.dll) & Windows Service is failing to start and uninstall
- MySQL query for the logic of three states from two fields
- Delphi 7 and SQLite
- Problem with a Delphi dbxpress application after upgrading Windows Server 2008 to Windows server 2012
- TFDQuery doesn't open by params value if SQL doesn't specify the param condition
- Memory issue when using dbExpress
- Rad Studio 10.2.3: Driver/Connection Registry File dbxconnections.ini not found
- How to fix 'Unable to find record. No key specified'?
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
You can't copy the content from Firebird table to an MySQL Table using a SQL statement. Another RDBMS has this functionality for example Sql Server has
Linked Serversand MySQL has FEDERATED engine (only works for MySQL Databases).So I eee two options to handle this task:
Iterate over the Datasets using a
SqlExpr.TSQLQueryor aSqlExpr.TSQLDataSetand then Insert each record (row) manually in the MySQL Table.Use a TClientDataSet to dump the Firebird table data using the
SaveToFilemethod and then with another TClientDataSet load the Data using theLoadFromFilemethod, finally you can merge the Data of the second TClientDataSet to the MySQL Table.