Friday, September 13, 2024

How to check postgres database start time ?


Query to check PostgreSQL database start time  : 





Thursday, September 12, 2024

Generate SSH key to setup Git Repo

Generate SSH key to setup Git Repo 


C:\Users\>ssh-keygen -t rsa -b 4096 -C "anurag.pandey@demo.com"

Generating public/private rsa key pair.

Enter file in which to save the key (C:\Users\/.ssh/id_rsa):

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in C:\Users\/.ssh/id_rsa

Your public key has been saved in C:\Users\/.ssh/id_rsa.pub

The key fingerprint is:

SHA256:sqJ1iaDi3R0VmwiFwKDOriahqrBfrRYMpvNERmO0jO4 anurag.pandey@demo.com

The key's randomart image is:

+---[RSA 4096]----+

| o+.. ..         |

|.o+o ..          |

|ooo. .   .       |

|+ =   . . +      |

| O.o  ..S+       |

|*...oo +.        |

|=E  =.=.         |

|Boo+o+. .        |

|Xooo.. .         |

+----[SHA256]-----+


C:\Users\>




copy and add id_rsa.pub to git setting -  Authentication keys



 

Monday, September 9, 2024

Source database providers for DMS Schema Conversion - DMS SCT

Source database  providers for DMS Schema Conversion - DMS SCT



=> DMS Schema Conversion supports the following data providers as sources for your migration projects.


  • Microsoft SQL Server version 2008 R2, 2012, 2014, 2016, 2017, and 2019
  • Oracle version 10.2 and higher, 11g and up to 12.2, 18c, and 19c, and Oracle Data Warehouse
  • PostgreSQL version 9.2 and higher
  • MySQL version 5.5 and higher