Search Results

Search found 34962 results on 1399 pages for 'drop database'.

Page 10/1399 | < Previous Page | 6 7 8 9 10 11 12 13 14 15 16 17  | Next Page >

• How to create SSIS package to update from one database to another database within same server

  - by Pavan Kumar

  My query is related to the answers i got for questions i had posted earlier in the same forum. I have a copy of a client database which is attached to SQL Server where the Central Database exists. The copy already contains the updated data. I just want to update from that copy to Central Database both holding same schema and are present in the same…

  Read the article

• SQL Server: avoiding hard coding of database name in cross-database views

  - by codeulike

  So, lets say you have two SQL Server Databases on the same server that reference each others tables in their Views, Functions and Stored Procedures. You know, things like this: use database_foo create view spaghetti as select f.col1, c.col2 from fusilli f inner join database_bar.dbo.conchigli c on f.id = c.id (I know that cross-database views…

  Read the article

• Oracle vocabulary, what is the mysql/mssql equivalent of a database

  - by jeph perro

  Hi, I need some help with vocabulary, I don't use Oracle that often but I am familiar with MySQL and MSSQL. I have an application I need to upgrade and migrate, and part of the procedure to do that involves exporting to an XML, create new database tables, then populate the new database tables from the XML export. In Oracle, my database…

  Read the article

• in-memory database in Python

  - by Claudiu

  I'm doing some queries in Python on a large database to get some stats out of the database. I want these stats to be in-memory so other programs can use them without going to a database. I was thinking of how to structure them, and after trying to set up some complicated nested dictionaries, I realized that a good representation would be…

  Read the article

• Solving the context menu problem with drag and drop in trees

  - by Frank Nimphius

  Normal 0 false false false EN-US X-NONE X-NONE …

  Read the article

• Drop database on DB2 9.5 - SQL1035N The database is currently in use

  - by Tommy

  I've never got this working the first time, but now I can't seem to do i at all. There is a connection pool somewhere using the database, so trying to drop the database when an application is using the database should give this error. The problem is there are no connection to the database when I issue these commands: db2 connect to…

  Read the article

• Drop database on DB2 9.5 - SQL1035N The database is currently in use

  - by Tommy

  I've never got this working the first time, but now I can't seem to do i at all. There is a connection pool somewhere using the database, so trying to drop the database when an application is using the database should give this error. The problem is there are no connection to the database when I issue these commands: db2 connect to…

  Read the article

• Managing Database Clusters - A Whole Lot Simpler

  - by mat.keep(at)oracle.com

  Clustered computing brings with it many benefits: high performance, high availability, scalable infrastructure, etc.  But it also brings with it more complexity.Why ?  Well, by its very nature, there are more "moving parts" to monitor and manage (from physical, virtual and logical hosts) to fault detection and failover…

  Read the article

• Steps to Mitigate Database Security Worst Practices

  - by Troy Kitch

  The recent Top 6 Database Security Worst Practices webcast revealed the Top 6, and a bonus 7th , database security worst practices: Privileged user "all access pass" Allow application bypass Minimal and inconsistent monitoring/auditing Not securing application data from OS-level user No SQL injection defense Sensitive…

  Read the article

• Oracle Announces Oracle Exadata X3 Database In-Memory Machine

  - by jgelhaus

  Fourth Generation Exadata X3 Systems are Ideal for High-End OLTP, Large Data Warehouses, and Database Clouds; Eighth-Rack Configuration Offers New Low-Cost Entry Point ORACLE OPENWORLD, SAN FRANCISCO – October 1, 2012 News Facts During his opening keynote address at Oracle OpenWorld, Oracle CEO, Larry Ellison…

  Read the article

• Offloading (Some) EBS 12 Reporting to Active Data Guard Instances

  - by Steven Chan

  For most Oracle Database users, Oracle Active Data Guard allows users to:Create a physical standby database for business continuity and disaster recoveryOffload reporting from the production database to the read-only physical standby databaseE-Business Suite customers have been able to use Active Data Guard to create…

  Read the article

• Faq and Best tips Regarding Learning Database ?

  - by AdityaGameProgrammer

  For a programmer with no prior exposure to databases What would be a good database to learn Oracle vs SQLserver vs MySQLvs PostgreSQL? I have come across lot of discussion MySQL and PostgreSQL and frankly I am confused on which to start with. Are these very different, in the sense if one had to switch, would the…

  Read the article

• Protecting offline IRM rights and the error "Unable to Connect to Offline database"

  - by Simon Thorpe

  One of the most common problems I get asked about Oracle IRM is in relation to the error message "Unable to Connect to Offline database". This error message is a result of how Oracle IRM is protecting the cached rights on the local machine and if that cache has become invalid in anyway, this error is thrown. …

  Read the article

• Letöltheto az Oracle Database Firewall 5.0

  - by Lajos Sárecz

  2010 május 20-án jelentettük be, hogy megvettük az adatbázis tuzfal megoldást fejleszto Secerno céget. Azóta viszonylag keveset lehetett hallani errol a termékrol, idehaza egyedül az oszi ITBN konferencián tartott róla eloadást Stuart Sharp szuk fél órában. Ráadásul a felvásárlás óta a terméket sem lehetett…

  Read the article

• MAA a Database Machine-nel, maximális rendelkezésre állás

  - by Fekete Zoltán

  Néhány napja jelent meg egy, a maximális rendelkezésre állást boncolgató Oracle fehérpapír :): Oracle Data Guard: Disaster Recovery for Sun Oracle Database Machine. Ez a dokumentum az Exadata környezetben az Oracle Data Guard használatát elemzi. Az utolsó oldalakon néhány rendkívül hasznos linket is…

  Read the article

• Passing data from one database to another database table (Access) (C#)

  - by SAMIR BHOGAYTA

  string conString = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=Backup.mdb;Jet OLEDB:Database Password=12345"; OleDbConnection dbconn = new OleDbConnection(); OleDbDataAdapter dAdapter = new OleDbDataAdapter(); OleDbCommand dbcommand = new OleDbCommand(); try { if…

  Read the article

• Tech Article: Getting Recursive - Querying Hierarchical Data in Oracle Database 11g Release 2

  - by OracleTechnologyNetwork

  A quick primer on querying hierarchical data in Oracle Database 11g Release 2

  Read the article

• Minimal set of critical database operations

  - by Juan Carlos Coto

  In designing the data layer code for an application, I'm trying to determine if there is a minimal set of database operations (both single and combined) that are essential for proper application function (i.e. the database is left in an expected state after every data access call). Is there…

  Read the article

• Oracle Database 11g Underground Advice for Database Administrators, by April C. Sims

  - by alejandro.vargas

  Recently I received a request to review the book "Oracle Database 11g Underground Advice for Database Administrators" by April C. Sims I was happy to have the opportunity know some details about the author, she is an active contributor to the Oracle DBA community, through her blog "Oracle…

  Read the article

• How do I Integrate Production Database Hot Fixes into Shared Database Development model?

  - by TetonSig

  We are using SQL Source Control 3, SQL Compare, SQL Data Compare from RedGate, Mercurial repositories, TeamCity and a set of 4 environments including production. I am working on getting us to a dedicated environment per developer, but for at least the next 6 months we are stuck with a…

  Read the article

• dependency analysis from C# code thru to database tables/columns

  - by fpdave

  I'm looking for a tool to do system wide dependency analysis in C# code and SQL-Server databases. Its looking like the only tool available that does this might be CAST (cast software), which is expensive and it does lots more besides that I dont really need. c# code thru to database…

  Read the article

• Oracle Database 11gR2 Windows 32 és 64 biten is megjelent

  - by Fekete Zoltán

  Teljessé vált az Oracle Database 11gR2 elérhetosége a legelterjedtebb szerver operációs rendszerekre. A Linux, Solaris, HP-UX, AIX után utolsónak a várt Windows platformra is megjelent és használható az Oracle Database 11g Release 2, és letöltheto innen:…

  Read the article

• Database Documentation - Lands of Trolls: Why and How?

  When database documentation is mentioned in an IT Department, everybody nods wisely, yet everyone does their best to avoid doing it. Attention to the database documentation can be the best invertment in time a development group can make. It is essential,…

  Read the article

• Announcing Oracle Audit Vault and Database Firewall

  - by Troy Kitch

  Today, Oracle announced the new Oracle Audit Vault and Database Firewall product, which unifies database activity monitoring and audit data analysis in one solution. This new product expands protection beyond Oracle and third party…

  Read the article

• Oracle Database 11g Helps Control Exponential Data Growth

  - by matthew.baier@oracle.com

  The 2010 ESG annual customer survey is now available. As part of it, ESG interviewed 300 customers about their IT priorities and, unsurprisingly, "Manage Data Growth" is top of the list. Perhaps less self-evident is the proposed solution to…

  Read the article

< Previous Page | 6 7 8 9 10 11 12 13 14 15 16 17  | Next Page >