Viewing 15 posts - 2,251 through 2,265 (of 3,061 total)
SQL_Quest-825434 (12/5/2009)
I know that this can be done by using string functions in SSIS.
... not really.
Why not relly on concatenate? you know: +
December 5, 2009 at 4:47 pm
praveen_delight 24284 (11/7/2009)
... u can't truncate table it is referenced by other table.but i am 100% sure that i disabled all the foreign keys?
This is a referential integrity issue and...
December 5, 2009 at 4:28 pm
millerfw (11/17/2009)
November 17, 2009 at 2:40 pm
Martin Wills (11/12/2009)
Having faced the same problem, I concluded that you just cannot use ORACLE reserved words for column names etc.Brackets, quotes etc do not help.
Statements above do not reflect...
November 13, 2009 at 8:52 am
"cloud" is a platform, not an application.
You can just forget about the word "cloud" and treat it as a remote server or group of servers - depending of what you...
October 30, 2009 at 4:40 pm
I've personally converted hundres of SQL Server storedprocs to Oracle.
Don't waste your time, rewrite them from scratch.
October 30, 2009 at 4:25 pm
With all due respect I strongly suggest not to proceed that way - the number of unknows will grew exponentially as time goes on.
Your job as a DBA is to...
October 29, 2009 at 6:49 am
I got is not a migration from database "A" to database "B" but a structural migration in the same database.
That's why I asked how large is the maintenance window you...
October 28, 2009 at 1:36 pm
16 Gig is a pretty manageable database.
Do it in one shot - why would you like to get into the myriad of troubles an on-the-go migration would cause?
Friday night users...
October 28, 2009 at 12:51 pm
Vicky-854895 (10/28/2009)
How is it possible to backup only newly entered data in every two weeks and restore that data on client site?
Backup/Restore was not designed as a replication...
October 28, 2009 at 12:12 pm
Steve Jones - Editor (10/28/2009)
If you bounce the instance, then memory, cache, etc. reset.
Exactly!
That's the difference in non-RAC Oracle you get a one-to-one relationship in between instance and database while...
October 28, 2009 at 12:06 pm
lucidspoon (10/28/2009)
October 28, 2009 at 12:03 pm
gaganks (10/28/2009)
I am trying to compare SQL Server to Oracle..
Happens that at this level SQL Server and Oracle are really different.
On the Oracle side an "instance" is actually a database...
October 28, 2009 at 11:58 am
Viewing 15 posts - 2,251 through 2,265 (of 3,061 total)