Posts

Showing posts from February, 2019

How to explore the existing code

MS SQL Database Backup with backward compatibility

Found about the tool from here: https://dba.stackexchange.com/questions/15682/sql-server-2012-backward-compatibility-for-backups-with-2008

Searched tool here: https://stackoverflow.com/questions/46517060/what-happened-to-the-sql-server-database-migration-wizard

Downloaded tool from here. https://blogs.msdn.microsoft.com/datamigration/dma/

Backup Using BCP utility

https://dba.stackexchange.com/questions/15682/sql-server-2012-backward-compatibility-for-backups-with-2008

Script
Data Backup

SELECT 
   'bcp SOURCEDATABASE.' + s.Name + '.' + t.NAME  + ' out d:\dbdump\' + s.Name + '.' + t.NAME  + '.dat -N -S SOURCESERVER\INSTANCE -UUSER -PPASSWORD'
--    'bcp DESTINATIONDATASE.' + s.Name + '.' + t.NAME  + ' in d:\dbdump\' + s.Name + '.' + t.NAME  + '.dat -N -S DESTINATIONSERVER\INSTANCE -UUSER -PPASSWORD -E -h TABLOCK -b 1000 -e d:\dbdump\' + s.Name + '.' + t.NAME  + '.ERRORS.dat'
FROM 
    sys.tables …