March 8, 2023 at 12:10 am
Hello!
Where can I find log to see how long it took for Import Data-tier application to create new database from the bacpac file?
Or is there any script that can be used to get the completion time?
Thanks in advance.
March 8, 2023 at 1:24 pm
I don't think that runing the import process of a dacpac is logged individually anywhere. The statements that create the database, tables, etc., are certainly logged (and maybe just getting the database creation time gets you what you need). But after that, it's traditional data definition language statements within T-SQL, so it's not like a backup & restore, which are logged. Best you could do is look at table create dates or update dates from the system views.
Why do you need 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
March 8, 2023 at 3:42 pm
The create date just provided date when it was created but not when it completed with the bacpac import.
I needed this information to provide estimate of how long it would take for DB to get created completely with the bacpac file provided, it would have been easier to get that information rathet than keeping eye for the duration.
thanks.
March 8, 2023 at 4:23 pm
I know of no way to do that beyond simple testing. Sorry.
"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
March 8, 2023 at 8:08 pm
If you use the command line with SqlPackage.exe - one of the options available is a log file. Instead of importing using SSMS - use the command line with the appropriate parameters.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 8, 2023 at 8:57 pm
If you use the command line with SqlPackage.exe - one of the options available is a log file. Instead of importing using SSMS - use the command line with the appropriate parameters.
Cool. I did not know that.
"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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply