TMSDUMP questions, comments..

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
[email protected]
Posts: 5
Joined: Tue 11 Mar 2014 17:33

TMSDUMP questions, comments..

Post by [email protected] » Sat 26 Oct 2019 06:35

Hello,
I have some questions to TMSdump component
1. is there any possibility to dump all of db objects with structure (create statement of tables, triggers, stored procedures etc..)?
2. is any possibility to disable comments generated into sql script ?
3. in comments there is always "-- Database: master", regardless of which database is dumped. For example, i dump database with name "mytestdb", every table of "mytestdb" is dumped correctly, but at the beginning of the SQL file is always comment "-- Database: master"
Thank you.

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: TMSDUMP questions, comments..

Post by Stellar » Mon 28 Oct 2019 12:12

1. Currently TMSDump doesn't allow creating database schema. Please note that the functionality you are interested in is present in the product line of our dbForge Studio products : https://www.devart.com/dbforge/sql/studio/
If the described functionality is required in DAC products, you can leave your suggestions at our UserVoice page
(https://devart.uservoice.com/forums/104 ... components), and if there are many votes for your suggestion, we will implement it.

2. You can turn off comments by setting the GenerateHeader option to False, for example:

Code: Select all

MSDump1.Options.GenerateHeader := False;
3. Unfortunately, we can't reproduce the issue. To investigate this behavior of SDAC, please compose a small sample demonstrating the issue and send it to us, including database objects creating scripts.

Post Reply