I have a database dump which has been dumped in SQL 2012. And when I try to restore it to a SQL2008, it was failing.
I have also SQL2014 licence and I can restore SQL2012 dump in SQL2014. Since my ultimate goal is to have the database in SQL2008, I scripted the database with its content in SQL2014 and save it a script file but this time, I end up with this,
So, my question is that how can i do this with sqlcmd?
The sqlcmd command must be run under SQL2014 but the authentication is via Windows Authentication. What is the command to export the healthy script in SQL2014?