VI Editor

Delete All lines using vi editor:- 

1) open the file > vi filename.ext

2) Delete all the lines >

1. Esc gg  > select all the lines
2. Esc dG > delete all the lines
3. If you want to paste already in clipboard - Esc i + right click 

 ------------------------------------------------------------------------------------

COMMENDS:

: > says commend starts
1 > Starting line
$ > end line
d > delete

zOthers_DOS

Find location of a file in DOS:-  dir filename.doc /s /p

SQL DB Migration

OnPremises to Azure:

1. Using Transactional Replication  - 
   
1. Points to consider
1. It requires short downtime.
2. Only push subscriptions to Azure are supported
3. Bi-directional, immediate, updatable, or peer to peer replication are not supported by Azure SQL Database
   
2. Steps
1. Set up Distributor and Publisher from OnPremises /
   
2. OnPremises, Replication > Local Publications > New Subscriptions - Configure azure DB
3. Monitor will be from OnPremises
   
3. Reference: By Prashanth Jayaram /

OnPremises to OnPremises