It was this line:

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –

That gave me an error, however

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add

does not.

qh

Really good article, this was something I had never attempted before and following your notes I now have SQL Server running on Ubuntu. ;o)

Only issue I had was with a...

Nice article, however one issue I have with DMA is that it displays a green tick mark for databases that will migrate with no issue, however it is still worth...

Is it possible to move this to 2016 Development and T-SQL forum?

Cheers

qh

Just be aware that the DMA tool shows a green tick mark for databases that will upgrade, however you should click the name as it will show any issues with...

You'll incur the wrath of Allan Hirt!

https://sqlha.com/2012/01/09/once-more-with-feeling-stop-using-activepassive-and-activeactive/

😉

qh

You can now use Database Backup Compression with TDE:
https://www.brentozar.com/archive/2016/07/tde-backup-compression-together-last/

Just make sure you are patched to the very latest level, as they are bringing fixes out...

Thank you Jeff, my pleasure.  This is part of a huge migration to Azure (we go live this weekend) however once I get my life back, yeah I think that's...

I am just please we found a solution as when you are dealing with 10+ year old code and you are moving it to Azure/Cloud you can run into issues...

Right, we have a solution!  Two things, one of the DBAs here decided to stick the offending code into a temp table.  Hey presto  - the process runs in just over...

Another update (for anyone that cares) 😀 I did some tests with running the process and using resource monitor to see what was going on whilst it was running.  CPU,...

Hi,

Do you mean move data from Oracle to a VM on Azure (IaaS) running SQL Server? Or do you mean Oracle to Azure SQL Database? (PaaS)

Rgds,

qh

Hi Rod,

Have you tried this method? 

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-migrate-your-sql-server-database

Rgds,

qh

Just a further update on this for anyone with similar issues.  Firstly we looked at the entire on-premise SQL environment to see what was happening:

1. MAXDOP was set...