Post reply

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

  • December 4, 2013 at 5:45 am

    #395939

    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

  • December 4, 2013 at 5:55 am

    #1670671

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

  • December 4, 2013 at 5:59 am

    #1670675

    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.

  • December 4, 2013 at 6:12 am

    #1670684

    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.

  • December 4, 2013 at 9:01 am

    #1670762

    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