1 st copy datav2 folder 2 nd delete sincav2(Go commend prompt sc delete SincAv2 ) 3 new datav2 download and paste on SincA file location 4 install Sinca 5 create database database name old database name 5 and blank last backup file 6 then stop SincA v2 7 go old datav2 folder ->open data folder->open database folder->copy all files 8 go new datav2 folder ->open data folder->open database folder-> paste and replace 9 start SincA v2 ( services ) then copy paste this quary ALTER TABLE accgroupmain DISCARD TABLESPACE; ALTER TABLE accgroups DISCARD TABLESPACE; ALTER TABLE accounts DISCARD TABLESPACE; ALTER TABLE acctransaction DISCARD TABLESPACE; ALTER TABLE active DISCARD TABLESPACE; ALTER TABLE addkit_items DISCARD TABLESPACE; ALTER TABLE agent DISCARD TABLESPACE; ALTER TABLE agentac DISCARD TABLESPACE; ALTER TABLE brand DISCARD TABLESPACE; ALTER TABLE buyget DISCARD TABLESPACE; ALTER TABLE category DISCARD TABLESPACE; ALTER TABLE centralsyncactivity DISCARD TABLESPACE; ALTER TABLE cheque_managemrnt DISCARD TABLESPACE; ALTER TABLE codeadv DISCARD TABLESPACE; ALTER TABLE company DISCARD TABLESPACE; ALTER TABLE complaints DISCARD TABLESPACE; ALTER TABLE customer DISCARD TABLESPACE; ALTER TABLE customergroup DISCARD TABLESPACE; ALTER TABLE customerpoint DISCARD TABLESPACE; ALTER TABLE daily_closing DISCARD TABLESPACE; ALTER TABLE damageadd DISCARD TABLESPACE; ALTER TABLE damagestatusadd DISCARD TABLESPACE; ALTER TABLE estimate DISCARD TABLESPACE; ALTER TABLE expence DISCARD TABLESPACE; ALTER TABLE giftcard DISCARD TABLESPACE; ALTER TABLE goodsreceipt DISCARD TABLESPACE; ALTER TABLE inventory DISCARD TABLESPACE; ALTER TABLE invoiceno DISCARD TABLESPACE; ALTER TABLE items DISCARD TABLESPACE; ALTER TABLE itemvariant DISCARD TABLESPACE; ALTER TABLE jobcard DISCARD TABLESPACE; ALTER TABLE journal DISCARD TABLESPACE; ALTER TABLE kitadd DISCARD TABLESPACE; ALTER TABLE leads DISCARD TABLESPACE; ALTER TABLE location DISCARD TABLESPACE; ALTER TABLE login DISCARD TABLESPACE; ALTER TABLE lpo DISCARD TABLESPACE; ALTER TABLE maincat DISCARD TABLESPACE; ALTER TABLE moredetails DISCARD TABLESPACE; ALTER TABLE opening DISCARD TABLESPACE; ALTER TABLE orders DISCARD TABLESPACE; ALTER TABLE poslog DISCARD TABLESPACE; ALTER TABLE powerof DISCARD TABLESPACE; ALTER TABLE powers DISCARD TABLESPACE; ALTER TABLE preproduction DISCARD TABLESPACE; ALTER TABLE production DISCARD TABLESPACE; ALTER TABLE purchaserequesition DISCARD TABLESPACE; ALTER TABLE quntityin DISCARD TABLESPACE; ALTER TABLE remortebarcode DISCARD TABLESPACE; ALTER TABLE reorderlevel DISCARD TABLESPACE; ALTER TABLE sales_items DISCARD TABLESPACE; ALTER TABLE sales_items_temp DISCARD TABLESPACE; ALTER TABLE serviceadd DISCARD TABLESPACE; ALTER TABLE servicestatusadd DISCARD TABLESPACE; ALTER TABLE sinca_pref DISCARD TABLESPACE; ALTER TABLE sincamenus DISCARD TABLESPACE; ALTER TABLE sincareports DISCARD TABLESPACE; ALTER TABLE staff_attendance DISCARD TABLESPACE; ALTER TABLE staff_jobtitle DISCARD TABLESPACE; ALTER TABLE staff_register DISCARD TABLESPACE; ALTER TABLE staff_workflow DISCARD TABLESPACE; ALTER TABLE stock DISCARD TABLESPACE; ALTER TABLE stocktransfer DISCARD TABLESPACE; ALTER TABLE stocktransferv2 DISCARD TABLESPACE; ALTER TABLE subcat DISCARD TABLESPACE; ALTER TABLE supplier DISCARD TABLESPACE; ALTER TABLE syc DISCARD TABLESPACE; ALTER TABLE sycdown DISCARD TABLESPACE; ALTER TABLE `update` DISCARD TABLESPACE; ALTER TABLE updatetable DISCARD TABLESPACE; ALTER TABLE userlog DISCARD TABLESPACE; 1st copy paste 2nd this ALTER TABLE accgroupmain IMPORT TABLESPACE; ALTER TABLE accgroups IMPORT TABLESPACE; ALTER TABLE accounts IMPORT TABLESPACE; ALTER TABLE acctransaction IMPORT TABLESPACE; ALTER TABLE active IMPORT TABLESPACE; ALTER TABLE addkit_items IMPORT TABLESPACE; ALTER TABLE agent IMPORT TABLESPACE; ALTER TABLE agentac IMPORT TABLESPACE; ALTER TABLE brand IMPORT TABLESPACE; ALTER TABLE buyget IMPORT TABLESPACE; ALTER TABLE category IMPORT TABLESPACE; ALTER TABLE centralsyncactivity IMPORT TABLESPACE; ALTER TABLE cheque_managemrnt IMPORT TABLESPACE; ALTER TABLE codeadv IMPORT TABLESPACE; ALTER TABLE company IMPORT TABLESPACE; ALTER TABLE complaints IMPORT TABLESPACE; ALTER TABLE customer IMPORT TABLESPACE; ALTER TABLE customergroup IMPORT TABLESPACE; ALTER TABLE customerpoint IMPORT TABLESPACE; ALTER TABLE daily_closing IMPORT TABLESPACE; ALTER TABLE damageadd IMPORT TABLESPACE; ALTER TABLE damagestatusadd IMPORT TABLESPACE; ALTER TABLE estimate IMPORT TABLESPACE; ALTER TABLE expence IMPORT TABLESPACE; ALTER TABLE giftcard IMPORT TABLESPACE; ALTER TABLE goodsreceipt IMPORT TABLESPACE; ALTER TABLE inventory IMPORT TABLESPACE; ALTER TABLE invoiceno IMPORT TABLESPACE; ALTER TABLE items IMPORT TABLESPACE; ALTER TABLE itemvariant IMPORT TABLESPACE; ALTER TABLE jobcard IMPORT TABLESPACE; ALTER TABLE journal IMPORT TABLESPACE; ALTER TABLE kitadd IMPORT TABLESPACE; ALTER TABLE leads IMPORT TABLESPACE; ALTER TABLE location IMPORT TABLESPACE; ALTER TABLE login IMPORT TABLESPACE; ALTER TABLE lpo IMPORT TABLESPACE; ALTER TABLE maincat IMPORT TABLESPACE; ALTER TABLE moredetails IMPORT TABLESPACE; ALTER TABLE opening IMPORT TABLESPACE; ALTER TABLE orders IMPORT TABLESPACE; ALTER TABLE poslog IMPORT TABLESPACE; ALTER TABLE powerof IMPORT TABLESPACE; ALTER TABLE powers IMPORT TABLESPACE; ALTER TABLE preproduction IMPORT TABLESPACE; ALTER TABLE production IMPORT TABLESPACE; ALTER TABLE purchaserequesition IMPORT TABLESPACE; ALTER TABLE quntityin IMPORT TABLESPACE; ALTER TABLE remortebarcode IMPORT TABLESPACE; ALTER TABLE reorderlevel IMPORT TABLESPACE; ALTER TABLE sales_items IMPORT TABLESPACE; ALTER TABLE sales_items_temp IMPORT TABLESPACE; ALTER TABLE serviceadd IMPORT TABLESPACE; ALTER TABLE servicestatusadd IMPORT TABLESPACE; ALTER TABLE sinca_pref IMPORT TABLESPACE; ALTER TABLE sincamenus IMPORT TABLESPACE; ALTER TABLE sincareports IMPORT TABLESPACE; ALTER TABLE staff_attendance IMPORT TABLESPACE; ALTER TABLE staff_jobtitle IMPORT TABLESPACE; ALTER TABLE staff_register IMPORT TABLESPACE; ALTER TABLE staff_workflow IMPORT TABLESPACE; ALTER TABLE stock IMPORT TABLESPACE; ALTER TABLE stocktransfer IMPORT TABLESPACE; ALTER TABLE stocktransferv2 IMPORT TABLESPACE; ALTER TABLE subcat IMPORT TABLESPACE; ALTER TABLE supplier IMPORT TABLESPACE; ALTER TABLE syc IMPORT TABLESPACE; ALTER TABLE sycdown IMPORT TABLESPACE; ALTER TABLE `update` IMPORT TABLESPACE; ALTER TABLE updatetable IMPORT TABLESPACE; ALTER TABLE userlog IMPORT TABLESPACE;