...
Code Block |
---|
lang | sql |
---|
title | Database Script : SQLSERVER |
---|
borderStyle | solid |
---|
|
USE [DBSyncDB]
CREATE TABLE [dbo].[account](
[id] [varchar](20) NULL,
[Name] [varchar](50) NULL,
[firstname] [varchar](50) NULL,
[lastname] [varchar](50) NULL,
[phone] [nchar](20) NULL,
[fax] [nchar](20) NULL,
[billingstreet] [varchar](200) NULL,
[billingcity] [varchar](50) NULL,
[billingstate] [varchar](50) NULL,
[billingcountry] [varchar](50) NULL,
[billingcode] [varchar](50) NULL,
[company] [nchar](100) NULL
) ON [PRIMARY]
GO
USE [DBSyncDB]
CREATE TABLE [dbo].[invoice](
[invoice_no] [nchar](10) NULL,
[customerid] [nchar](100) NULL,
[item] [nchar](100) NULL,
[itemdesc] [nchar](100) NULL,
[quantity] [nchar](10) NULL,
[uom] [nchar](50) NULL,
[salesprice] [nchar](10) NULL,
[total] [nchar](10) NULL,
[billaddress] [nchar](100) NULL,
[billingcity] [nchar](100) NULL,
[billingstate] [nchar](100) NULL,
[billingpostalcode] [nchar](10) NULL,
[billingcountry] [nchar](100) NULL,
[date] [nchar](50) NULL
) ON [PRIMARY]
GO
|
Code Block |
---|
lang | sql |
---|
title | Database Script : MYSQL |
---|
borderStyle | solid |
---|
|
CREATE TABLE `dbsyncdb`.`account` (`id` VARCHAR(20) DEFAULT NULL,`Name` VARCHAR(50) DEFAULT NULL,`firstname` VARCHAR(50) DEFAULT NULL,
`lastname` VARCHAR(50) DEFAULT NULL,`phone` VARCHAR(20) DEFAULT NULL,`fax` VARCHAR(20) DEFAULT NULL,
`billingstreet` VARCHAR(200) DEFAULT NULL,`billingcity` VARCHAR(50) DEFAULT NULL,`billingstate` VARCHAR(50) DEFAULT NULL,
`billingcountry` VARCHAR(50) DEFAULT NULL,`billingcode` VARCHAR(50) DEFAULT NULL,`company` VARCHAR(100) DEFAULT NULL
)
ENGINE=INNODB DEFAULT CHARSET=utf8;
/*Table structure for table `invoice` */
CREATE TABLE `dbsyncdb`.`invoice` (`invoice_no` CHAR(10) DEFAULT NULL,`customerid` CHAR(100) DEFAULT NULL,`item` CHAR(100) DEFAULT NULL,
`itemdesc` CHAR(100) DEFAULT NULL,`quantity` CHAR(10) DEFAULT NULL,`uom` CHAR(50) DEFAULT NULL,`salesprice` CHAR(10) DEFAULT NULL,
`total` CHAR(10) DEFAULT NULL,`billaddress` CHAR(100) DEFAULT NULL,`billingcity` CHAR(100) DEFAULT NULL,
`billingstate` CHAR(100) DEFAULT NULL,`billingpostalcode` CHAR(10) DEFAULT NULL,`billingcountry` CHAR(100) DEFAULT NULL,
`date` CHAR(50) DEFAULT NULL)
ENGINE=INNODB DEFAULT CHARSET=utf8;
|
Code Block |
---|
lang | sql |
---|
title | Database Script : ORACLE |
---|
borderStyle | solid |
---|
|
CREATE TABLE "SYS"."ACCOUNT" ("id" VARCHAR(20 BYTE) DEFAULT NULL,"Name" VARCHAR(50 BYTE) DEFAULT NULL,"firstname" VARCHAR(50 BYTE) DEFAULT NULL,
"lastname" VARCHAR(50 BYTE) DEFAULT NULL,"phone" VARCHAR(20 BYTE) DEFAULT NULL,"fax" VARCHAR(20 BYTE) DEFAULT NULL,
"billingstreet" VARCHAR(200 BYTE) DEFAULT NULL,"billingcity" VARCHAR(50 BYTE) DEFAULT NULL,"billingstate" VARCHAR(50 BYTE) DEFAULT NULL,
"billingcountry" VARCHAR(50 BYTE) DEFAULT NULL,"billingcode" VARCHAR(50 BYTE) DEFAULT NULL,
"company" VARCHAR(100 BYTE) DEFAULT NULL
);
/*Table structure for table `invoice` */
CREATE TABLE "SYS"."INVOICE" ("invoice_no" CHAR(10 BYTE) DEFAULT NULL,"customerid" CHAR(100 BYTE) DEFAULT NULL,"item" CHAR(100 BYTE) DEFAULT NULL,
"itemdesc" CHAR(100 BYTE) DEFAULT NULL,"quantity" CHAR(10 BYTE) DEFAULT NULL,"uom" CHAR(50 BYTE) DEFAULT NULL,"salesprice" CHAR(10 BYTE) DEFAULT NULL,
"total" CHAR(10 BYTE) DEFAULT NULL,"billaddress" CHAR(100) DEFAULT NULL,"billingcity" CHAR(100) DEFAULT NULL,
"billingstate" CHAR(100 BYTE) DEFAULT NULL,"billingpostalcode" CHAR(10 BYTE) DEFAULT NULL,"billingcountry" CHAR(100 BYTE) DEFAULT NULL,
"date" CHAR(50 BYTE) DEFAULT NULL);
|
Note : Make sure both the tables have sample data in them before they can be mapped within DBSync.
...
- Similarly right-click on the DBmap state now and select "properties". Click on* {}*Edit{} link besides *****_map.xml file to open the mapping page in a new window or a new tab. Enter the following mapping.
...
Code Block |
---|
customerid,billaddress,billingcity,billingstate,billingpostalcode,billingcountry,date,
invoice_no,[item,itemdesc,quantity,salesprice]
|
- Now configure the DBwriter
...