Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I can not export all data from the database in mssql studio 2012 Expand / Collapse
Author
Message
Posted Wednesday, December 4, 2013 5:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 14, 2013 8:12 AM
Points: 4, Visits: 86
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
Post #1519574
Posted Wednesday, December 4, 2013 5:55 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 5:03 AM
Points: 701, Visits: 1,260
you want all tables data in a single FLAT File is that what you are looking for ?
Post #1519578
Posted Wednesday, December 4, 2013 5:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 14, 2013 8:12 AM
Points: 4, Visits: 86
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.
Post #1519582
Posted Wednesday, December 4, 2013 6:12 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 5:03 AM
Points: 701, Visits: 1,260
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.
Post #1519591
Posted Wednesday, December 4, 2013 9:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 14, 2013 8:12 AM
Points: 4, Visits: 86
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
Post #1519680
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse