December 4, 2013 at 5:45 am
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
you want all tables data in a single FLAT File is that what you are looking for ?
December 4, 2013 at 5:59 am
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
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
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy