I can not export all data from the database in mssql studio 2012

  • Hello I opened - tastks - Exporting

    And have chosen the destination - unstructered (flat) file. But the wizard proposes to export only one table (dbo.Acocount) and all the others from the list are not exported.

    How can I export ALL the data into one file.

    I need to do this to edit the syntax in the editor and then import this data and database structure into Postgresql

  • you want all tables data in a single FLAT File is that what you are looking for ?

  • I think so.

    I need then to migrate the data to PostgerSql database. I think all tables must be in one file.

    But nevertheless, how to make even in different files but with one click.

    There a lot of tables in that database.

  • you wont be able to determine the data if its all written in a single flat file.

    these should be single file per object(table). you have make a custom SSIS package to generate multiple Files for the related Tables.

  • Yes but when I export the db to the Excel - the size of excel is 3 mb. The database has 10gb size/

    I created an excel list file. And chosen it as destination

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply