Connect SQL Server with Visual Studio 2019

Hello Programmers, here is the article to connect SQL server with visual studio. Microsoft visual studio has nice facility where you can easily connect any database with visual studio. this article i am using SQL Server 2019 and Visual Studio 2019.Let’s see the all important steps to connect VS with ssms. 1.Click “Tools” Tab and […]

Migrate Oracle Tables to SQL Server

Hi Programmer,Here is the article to migrate oracle database tables into Microsoft SQL server.First we need to download and install ssma from Microsoft sites. To copy oracle database tables into Microsoft SQL server. let’s follow some steps. 1.Click File Tab next click “New Project” Give meaningful Project Name, suitable location and choose you SQL server […]

How to write SQL query in Visual Studio

How to execute SQL query in Visual Studio 2019.Hi Guy’s here are the steps to writes SQL server query in visual studio . Let’s follow the steps.step 1 : click Tools tab, click SQL Server –> New Query. step 2 : select Local. select any available server. note SSMS must be installed. automatically Server Name […]

Connect SQL Server with Visual Studio Code

Hello Friends, in this article , i m going to explain all steps to connect sql server with visual studio code. Step 1 : Open visual studio code, click extensions. write in search box SQL server and click install. Step 2 : After installing SQL Server(mssql) click View Tab and select Command Palette and click. […]

Connect Sybase with Oracle SQL Developer

using SQL Developer to connect Sybase databases. step 1 : open Oracle SQL Developer . click Tools Tab Next click Preferences. step 2 : inside preferences select Database. step 3 : inside Database “Third Party JDBC Drivers step 4 : inside “Third Party JDBC Drivers” click Add Entry. now you have to give jdbc driver. […]

Connect SQL Server with Oracle SQL Developer

Using SQL Server Database connecting Oracle SQL developer. step 1 : open Oracle SQL Developer . click Tools Tab Next click Preferences. step 2 : inside preferences select Database. step 3 : inside Database “Third Party JDBC Drivers step 4 : inside “Third Party JDBC Drivers” click Add Entry. now you have to give jdbc […]

Encrypt Columns in Sql Server

This is newly feature comes after SQL Server 2016 version. By using Encrypt Columns we can convert columns into Coded format.¬† the coded columns are the combinations of alphanumeric values. Converting Columns into Encrypt format, its hard to understand columns records. let’s see the steps to convert columns into Encrypt format— 1.¬† select the Database, […]

Change Data Capture

Change Data Capture vs Change Tracking

Difference 1 : Change Tracking : Change Tracking Identifies the rows that have changed in the Table . But Change data capture : CDC is a tool that detects and records changes made to a database. It display before updated records and after updated records in the Table . Difference 2 : Change Tracking : […]

Change Data Capture

Change Data Capture in SQL Server

Change data capture, or CDC, is a tool that detects records changes made to a database.  Change Data Capture expose INSERTs, UPDATEs, and DELETEs applied to SQL Server tables.  It Display Historical Records as well current Records. To Detects data changes on Table, First You should enable “Sql Server Agent ” . Enable Database for […]

Change Tracking in SQL Server

Change Tracking identifies the rows that have changed in the Table . Most of the Things in SQL SERVER . We can do by Two ways — 1 . First Graphically 2. Second by Query. Enable Change Tracking on Database . By Graphically : Right click on Database . Select Property . click on “Change […]