how can I get a Dump of a database with many tables to a flat file that is human readable quickly? Like csv or SQL create/update phrases. Or any binary format that can be viewed from a text viewer is fine.
The data export from management studio only allows one table at a time (?) which is not enough, I need all, there are many. Or how to circumvent this?
Actually I need to find some data in the database and understand which table and which column it belongs. We need this in a live system that belongs to us but the 3rd party developers are not reachable now, but for us it is enterprise critical to get it quickly.
I can access the db also in ms access, but to write such code would take too much time now (unless it is already available in this form)
There is also aqua data studio 4.7.2 available here
Microsoft SQL Server Management Studio 9.00.3042.00 Microsoft Analysis Services-Clienttools 2005.090.3042.00 Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710) Microsoft MSXML 2.6 3.0 6.0 Microsoft Internet Explorer 7.0.5730.13 Microsoft .NET Framework 2.0.50727.3603 Betriebssystem 5.2.3790