Database bacpac import

Question

Database bacpac import

steveaustin219

Valued Member

Points: 63
More actions
October 28, 2019 at 8:05 am

#3692288

my bacpac import timed out , but after loading all the tables data and enabled some indexes. Instead of rerunning the whole process, I enabled all the indexes myself and all the check constraints and foreign constraints and the triggers.
i have also done a schema comparison and all the data and objects are mostly matching. Is there anything else I need to do or it should be ok

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 399289 More actions · Answer 1

Sounds like you're probably OK. Update the statistics after a data load like this.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

steveaustin219 Valued Member Points: 63 More actions · Answer 2

Thanks grant , glad to hear that , just confirming that because the bacpac import already started rebuilding indexes phase, as long as I rebuild all indexes and enable foreign key and check key constraints there’s nothing else that needs to be done, theres nothing that bacpac might do at the end , in regards to statistics I think azure database update statistics on its own automatically

Grant Fritchey SSC Guru Points: 399289 More actions · Answer 3

If you're rebuilding all the indexes, stats are not a worry. However, since you're doing a bunch of partial updates, I'd be a bit more concerned that simply enabling indexes doesn't get the stats up to date in the same way. Statistics are maintained in Azure SQL Database the same way as they are in SQL Server. So, the same positives and negatives apply. There's nothing extra in terms of statistics maintenance within Azure.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

erfankarimian Newbie Points: 1 More actions · Answer 4

Hello. I want to get address a folder like "D:\MOVIE\March 2019" in SQL SERVER DATA TOOLS and zip that folder and then copy it to the desktop after zipping? Can I Help What I Do Step by Step?

Phil Parkin SSC Guru Points: 247180 More actions · Answer 5

erfankarimian wrote:

Hello. I want to get address a folder like "D:\MOVIE\March 2019" in SQL SERVER DATA TOOLS and zip that folder and then copy it to the desktop after zipping? Can I Help What I Do Step by Step?

Please start a new thread ... this question does not relate to the rest of the post.

Also, note that SSDT is a development environment, not a solution. You could be talking about SQL Server, SSIS, SSAS, SSRS ... and we wouldn't know from your question.