Hello,
Looking to extract the csv format for all tables in the sql server. I got the python but not much user friendly .But how do i write power shell or python and debug in side the toad.
Or
any innovative ideas to extract the CSV format from the database daily jobs etc helpful
Welcome to the Toad for SQL Server forum.
There's a far easier way within Toad to extract data from SQL Server tables than using Python or PowerShell (unless you're doing something very advanced).
Simply use Toad's Export wizard, which gives you the ability to export to many popular formats, and even export some/all of the tables in some/all of the databases on a SQL Server instance. See quick gif below... Hope this helps.
This is scheduled job and replace old files daily run. Also The table header info ang count (*) trailer info count for csv