This tutorial deals with implementing Database to Database integration using DBSync. The tutorial shows how data exchange can happen between 2 MYSQL databases.
create table `salesforce`.`dbAccount` ( `AccountID` varchar(100) NOT NULL , `AccountName` text NOT NULL , `BillingStreet` text , `BillingPostalCode` numeric(20) , `AnnualRevenue` decimal(30,2) , `CreatedDate` date , `LastModifiedDate` datetime , `NumberOfOfficeLocations` int , PRIMARY KEY (`AccountID`) ); create table `salesforce`.`dbaccountnew` (`AccountID` varchar (100) NOT NULL, `AccountName` varchar (300) NOT NULL, `BillingAddress` varchar (500), `AnnualRevenue` Decimal (50,2), `CreatedDate` datetime , `LastModifiedDate` datetime , `NumberOfOfficeLocations` int, PRIMARY KEY (`AccountID`) ); |
Select AccountID, AccountName, BillingStreet, BillingPostalCode, AnnualRevenue, CreatedDate from dbaccount |