I have a .bacpac
file from a large database.
The problem is it contains one table which has files stored as varbinary
and is extremely large. This table is to large to restore locally.
I would like to restore the .bacpac
file, but instruct it to ignore that varbinary
column.
If this were RAW BCP, I know I could construct a format file for this table which simply skips the column (leaving it null, which would be fine). However, I cannot figure out how or where to apply a BCP command in the structure of the .bacpac
file that would do that?
Is there a way to provide instruction to a .bacpac
restore to ignore a single table column (like I could in BCP)? Or perhaps a way to edit the .bacpac
file (zip) contents to insert an instruction for the BCP operation on this single table?
1条答案
按热度按时间r6l8ljro1#
I'm not aware of a direct option to selectively aware ignore specific columns during a bacpac restore. 2 options I can think of:
Option 1
Option 2