Database

31-Aug-10 20:56

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

Simon_Whale31-Aug-10 22:03

31-Aug-10 22:03

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.

ps_prakash0231-Aug-10 22:40

31-Aug-10 22:40

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.

Simon_Whale31-Aug-10 22:44

31-Aug-10 22:44

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.

ps_prakash0231-Aug-10 23:01

31-Aug-10 23:01

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;

Simon_Whale31-Aug-10 23:12

31-Aug-10 23:12

 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.

ps_prakash0231-Aug-10 23:16

31-Aug-10 23:16

so we have to go with manual process if we don't have oracle database.

Bernhard Hiller31-Aug-10 23:03

Bernhard Hiller

31-Aug-10 23:03

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.

ps_prakash0231-Aug-10 23:18

31-Aug-10 23:18

Thanks bhiller,

I'm downloading it. but it seems to be a huge file.

Ultralite and c#

pestman31-Aug-10 19:18

pestman

31-Aug-10 19:18

Hello I have been trying to learn c# and accessing ultralite I have found the link here 10 Steps to Creating a Windows Mobile Database Application Using .NET and UltraLite 10[^] Which has helped i got it working but what im trying to figure out is how to add a listbox that is controlled by the combobox. What would happen is I select say tom than the list box displays the address.I cant seem to get anywhere with it my previous coding experience is with html and vbscript.

Any help would be appreciated or if you can point me in the right direction
Thank You
Aaron

Re: Ultralite and c#

Steven J Jowett2-Sep-10 1:39

Steven J Jowett

2-Sep-10 1:39

Not a database related question, more a C# question.

What you need to do is Handle the TextChanged or ValueChanged event of the ComboBox. In the event handler, populate the ListBox with the required data from your database etc.

Steve Jowett
-------------------------
Real Programmers don't need comments -- the code is obvious.

retrive deleted column

moein.serpico31-Aug-10 3:20

moein.serpico

31-Aug-10 3:20

hi guys
i delete a column in a table UNWITTING
how can i restore my mistake
and retrieved my deleted column

Dalek Dave31-Aug-10 3:34

Dalek Dave

31-Aug-10 3:34

Ctrl Z ?

How's the new job?

------------------------------------

I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave

CCC League Table Link
CCC Link[^]

SimulationofSai31-Aug-10 6:16

SimulationofSai

31-Aug-10 6:16

If you do not know how to help, shut up.

And provided you can read and comprehend

"Insults, slap-downs and sarcasm aren't welcome. Let's work to help developers, not make them feel stupid."

SG
Aham Brahmasmi!

PIEBALDconsult31-Aug-10 10:47

PIEBALDconsult

31-Aug-10 10:47

SimulationofSai wrote:
"Insults, slap-downs and sarcasm aren't welcome.

Yes they are... as long as they're directed at someone else.

Dalek Dave31-Aug-10 21:03

Dalek Dave

31-Aug-10 21:03

You need to develop a sense of humour and read earlier threads, ass hat.

Simon_Whale31-Aug-10 3:37

31-Aug-10 3:37

if it had data in it then restore from backup.

As barmey as a sack of badgers

MidwestLimey31-Aug-10 4:26

MidwestLimey

31-Aug-10 4:26

You can't per se, the data is gone.
However as Simon said you can restore from the last backup. S??? happens, that's what backups are for.

If this is a production DB on the otherhand, s??? should rarely happen to them, which means an awfull lot of arselicking would be required.
If there are no backups, divert blame to the DBA as s??? happens and that's what backups should be for.
If you are the DBA, and no backups have been performed, and this was the dev environment, copy the production environment to dev.
If you are the DBA, and no backups have been performed, and this was the production environment find the nearest exit and polish your resume.

Good luck!

062142174041062102

Corporal Agarn1-Sep-10 5:41

Corporal Agarn

1-Sep-10 5:41

Sorry I did not see this sooner, so this is too late.

Depending on your disaster recovery model you could do a point in time restore from your backup. This would mean you need full recovery mode, and using the transaction logs.