How to import /integrate SQL Server database BACPAC dump file into Snowflake.

File has an extension of .bacpac and currently it is stored in AWS S3 bucket.

anu09sha

posted on 06 Mar 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




nVector06-Mar-20

@anu09sha  I edited the question for more context

AFAIK the BACPAC files are for transferring DBs within the Microsoft ecosystem. There is no ready-made program that can do this import into Snowflake. You will have to reverse engineer to find out the process and build something new for Snowflake

How about migrating individual table DDLs and then copying the data one by one ? I understand its not as efficient as one big dump file, but thats the approach thats prevalent. How many such database files are you talking about ?