CONVERTING ORACLE SCRIPT TO SQL SERVER
-
Hi, I've tables, procedures and functions scripts of a oracle database. i need to convert it to sql server scripts. how to do that?. we don't have oracle database but we have only scripts for the oracle database objects, is it possible to convert those scripts to sql server and create those objects in sql server database. sql server version is 2005. Thanks in Advance
-
Hi, I've tables, procedures and functions scripts of a oracle database. i need to convert it to sql server scripts. how to do that?. we don't have oracle database but we have only scripts for the oracle database objects, is it possible to convert those scripts to sql server and create those objects in sql server database. sql server version is 2005. Thanks in Advance
try this oracle to sql server conversion
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
try this oracle to sql server conversion
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
SQL Server Migration Assistant for Oracle (SSMA for Oracle), does it requires oracle client in my system, i don't have any oracle in my system at the same time i'm very new to oracle. i've tried some trial tools but everything require oracle database but i've only oracle script. how to convert those scripts to sql server based one.
-
SQL Server Migration Assistant for Oracle (SSMA for Oracle), does it requires oracle client in my system, i don't have any oracle in my system at the same time i'm very new to oracle. i've tried some trial tools but everything require oracle database but i've only oracle script. how to convert those scripts to sql server based one.
best thing I could suggest is to post some of the code and we'll give you a head start on its conversion
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
best thing I could suggest is to post some of the code and we'll give you a head start on its conversion
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
Hi, I'm posting sample table script CREATE TABLE "DEV"."APP_ID" ( "AID" NUMBER NOT NULL ENABLE, "ID_TYPE" NUMBER NOT NULL ENABLE, "CREATED" DATE DEFAULT sysdate NOT NULL ENABLE, "CREATED_BY" VARCHAR2(30 BYTE) NOT NULL ENABLE, "UPDATED" DATE DEFAULT sysdate NOT NULL ENABLE, "UPDATED_BY" VARCHAR2(30 BYTE) NOT NULL ENABLE, PRIMARY KEY ("AID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "APPLICATION_DATA" ENABLE, FOREIGN KEY ("ID_TYPE") REFERENCES "DEV"."ID_TYPE" ("ID_TYPE") ENABLE ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "APPLICATION_DATA" ; CREATE OR REPLACE TRIGGER "DEV"."T_APP_ID" BEFORE INSERT OR UPDATE ON APP_ID FOR EACH ROW BEGIN :new.updated := sysdate; :new.updated_by := username; if inserting then :new.created_by := username; end if; END T_APP_ID; / ALTER TRIGGER "DEV"."T_APP_ID" ENABLE;
-
Hi, I've tables, procedures and functions scripts of a oracle database. i need to convert it to sql server scripts. how to do that?. we don't have oracle database but we have only scripts for the oracle database objects, is it possible to convert those scripts to sql server and create those objects in sql server database. sql server version is 2005. Thanks in Advance
Also Oracle offers free versions of their engine for developers - get one. Then get that database with those scripts, and then use a conversion tool as already suggested.
-
Hi, I'm posting sample table script CREATE TABLE "DEV"."APP_ID" ( "AID" NUMBER NOT NULL ENABLE, "ID_TYPE" NUMBER NOT NULL ENABLE, "CREATED" DATE DEFAULT sysdate NOT NULL ENABLE, "CREATED_BY" VARCHAR2(30 BYTE) NOT NULL ENABLE, "UPDATED" DATE DEFAULT sysdate NOT NULL ENABLE, "UPDATED_BY" VARCHAR2(30 BYTE) NOT NULL ENABLE, PRIMARY KEY ("AID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "APPLICATION_DATA" ENABLE, FOREIGN KEY ("ID_TYPE") REFERENCES "DEV"."ID_TYPE" ("ID_TYPE") ENABLE ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "APPLICATION_DATA" ; CREATE OR REPLACE TRIGGER "DEV"."T_APP_ID" BEFORE INSERT OR UPDATE ON APP_ID FOR EACH ROW BEGIN :new.updated := sysdate; :new.updated_by := username; if inserting then :new.created_by := username; end if; END T_APP_ID; / ALTER TRIGGER "DEV"."T_APP_ID" ENABLE;
CREATE TABLE App_ID
(
aid INTEGER PRIMARY KEY NONCLUSTERED,
id_type INTEGER FOREIGN KEY REFERENCES dev.id_type,
created DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
created_by varchar(30) NOT NULL,
updated DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_by varchar(30) NOT NULL,
)drop table app_id
been a bit too long since I've done Oracle to remeber triggers so here an msnd refernce link triggers
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
CREATE TABLE App_ID
(
aid INTEGER PRIMARY KEY NONCLUSTERED,
id_type INTEGER FOREIGN KEY REFERENCES dev.id_type,
created DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
created_by varchar(30) NOT NULL,
updated DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_by varchar(30) NOT NULL,
)drop table app_id
been a bit too long since I've done Oracle to remeber triggers so here an msnd refernce link triggers
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
so we have to go with manual process if we don't have oracle database.
-
Also Oracle offers free versions of their engine for developers - get one. Then get that database with those scripts, and then use a conversion tool as already suggested.
Thanks bhiller, I'm downloading it. but it seems to be a huge file.