DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 9

changes.mady.by.user Vishwanath B

Saved on

compared with

New Version 10

changes.mady.by.user Vishwanath B

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Create tables "dbAccount" and "dbAccountNew" in Database with following script.  
    Code Block
    langsql
    titleDatabase Scripts
    borderStylesolid
    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`)
 );
  • Enter some test data in "dbAccount" table. Go To www.mydbsync.com.

...