0
votes
0answers
2 views

Replicate Postgres 9.2 to 9.4 with no downtime

My current set up has a database running on Postgres 9.2.4 and would like to move from AWS EC2 to RDS. However, AWS requires Postgres be running at least Postgres 9.4 in order to perform this ...
0
votes
0answers
7 views

How to make a query on multiple columns without writting all possible permutations?

I'm at my first question on stackexchange, as i have a few days since I struggle on this matter: I want to make a complex query(PLSQL) on a table that has col1,col2,col3,col4,col5 having values like ...
0
votes
0answers
5 views

Importing .dmp file into SQL developer: Do I need to import seperately for each table?

I have a large .dmp file which I would like to import into SQL developer. This contains all the data I want to import across several Schemas. Do I need to split this up into each separate table in ...
0
votes
0answers
13 views

sql server cannot find local sql accounts

All local sql accounts are getting a windows application event log The description for Event ID 18456 from source MSSQLSERVER cannot be found. Either the component that raises this event is not ...
0
votes
2answers
15 views

display both null and not null under same id but not both null or not null like XOR logic

In this table need to select only the id which has both null and not null value and it should not be both not null or both are null in col1
0
votes
0answers
7 views

how to fixed this mysql 5.5 crash?

[root@DB-Server-master bin]# mysqld_safe --user=mysql 160429 12:10:55 mysqld_safe Logging to '/data/mysql/data/log/mysql-error.log'. 160429 12:10:55 mysqld_safe Starting mysqld daemon with databases ...
0
votes
0answers
7 views

'OraOLEDB.Oracle' provider is not registered on the local machine - Oracle Database Client 12C

I have some problem with connect to the Oracle Database by Oracle Client. I installed on laptop oracle client - version 32 bit. I can connect to the database from laptop when i use 64 bit ...
0
votes
1answer
13 views

How to duplicate the database in postgresql?

I need to duplicate the existing database including its schema and structure to another new database. I need this in shell command environment and not in pgadmin. Please kindly help me. nohup pg_dump ...
0
votes
1answer
24 views

How can I better model the relationships in this project?

I'm developing an internal tool (as an intern). We deal with a lot of hardware, which is all custom and managers have a hard time knowing who is developing on what machine. The three main things to ...
0
votes
0answers
6 views

Mongo crash after 2 seconds of starting

Mongod service crashes after 2-5 seconds of starting , i cant define why exactly ! here are the logs : systemctl status mongod.service mongod.service - High-performance, schema-free ...
0
votes
0answers
9 views

Having two data folder in my postgresql setup- Postgresql

I am using centos 6 and installed Postgresql_9.4 using the following commands yum install postgresql postgresql-contrib postgresql-client pgadmin3 yum install postgresql-server After that i ...
0
votes
0answers
15 views

Single instance SQL server, needs limited access to remote network resource

I have a general purpose SQL server at a client site. It runs a bunch of smallish databases, mainly servicing in-house applications and the odd third party DB. Nothing very exciting in a lot of ways, ...
-1
votes
0answers
11 views

Getting Oracle tablespace error even if autoextensible is 'YES'

I am getting an error saying tablespace is critical, when doing operations on Oracle 9i (autoextensible is 'YES') from an application. What could be the reason behind this error? In dba_data_files ...
0
votes
0answers
15 views

Tools to compare two versions of the same database [on hold]

Does anyone know of other open source tools similar to sqldiffframework that are either in active development or that are written in Java? The assumption is that the schemas are identical but the ...
1
vote
1answer
12 views

Finding opening and closing price using sqlite GROUP BY statement (accessing main query alias in subquery)

I want to preface this post by saying that I am a SQL(ite) newbie. My main goal is to find the opening/closing/high/low/average prices of each 5 minute interval of these stock prices. I can get the ...
0
votes
0answers
7 views

How to set mysqldump using /*!40101 SET character_set_client = utf8mf4 */;?

When I use mysqldump to export mysql database, it always produce a dump.sql containing ...some other things... /*!40101 SET character_set_client = utf8*/; ...some other things... This is the ...
0
votes
1answer
5 views

Cant initialize MySQL. “mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended”

I am doing a fresh install of MySQL on Fedora 22. After I run mysql_install_db I try to start the daemon using mysqld_safe but it does not work. The system says: mysqld_safe Logging to ...
0
votes
0answers
8 views

Table data is not getting dumped

This is just for test purpose. I'm taking backup (INNODB DB) with --single-transaction and from another terminal I'm running alter table on one of the table of same DB on which dump command is ...
0
votes
0answers
26 views

Not able to see systemViews

I recently installed SQL 2016 RC3 and latest version of SSMS (april 2016 preview).Today i subsribed to Azure S0 database .When i tried to check system views in Azure and in my local database ,i am not ...
0
votes
0answers
15 views

Slot Time Challenge - Doctor Appointment database schema

I am trying to make a doctor appointment system where patient online will have two options: First time visit (this visit should be 20 mins) Follow up visit (this visit should be 10 mins) ...
-2
votes
1answer
17 views

pick data from multiple tables

I am new to MySQL. My question is how to make a filter like amazon product. I made a matrimony site with filter. I wrote a query to access data from multiple tables. I give foreign key to another ...
0
votes
0answers
8 views

How to upgrade PostgreSQL 7.3 to 9.3?

I want to upgrade the PostgreSQL database from 7.3 to 9.3. Please help me how to perform the upgrade.
0
votes
1answer
9 views

Could not connect to the specific instance. MySQL error number 1045. Access denied for user 'root'@'my public ip' (using password:YES)

I was using MySQL query Browser in my system and type the IP address of the remote Server and log in. I tried to create a store procedure and scheduled an event to call the procedure every two ...
5
votes
4answers
196 views

UNION ALL or other ways to return first row of result-set

I am writing a table valued function to geocode an address based on its Suburb, State and Postcode. I try to geocode the address using different methods, in order of decreasing accuracy: Exact match ...
0
votes
0answers
26 views

Database got corrupted and I want to recover only data from it [on hold]

I have Oracle Database 10g Express Edition. The database has some important data and has got corrupted. I don't have a backup of it and want to recover the data from it. Is there any free tool or ...
0
votes
0answers
11 views

MySql Error : Database page corruption on disk

Recently Ive setup a xampp in my store location. on Windows 7 32 bit, 2GB RAM - Pentium PC. (XAMPP) xampp-win32-5.5.19-0-VC11 PHP application is Point of Sale. With latest mysql server and PHP 5.5. ...
1
vote
0answers
18 views

Materialized Views and Indexes

Is there any way to force PostgreSQL to use an index that I created on a materialized view table? I tried every combination possible of moving the column attributes around to make Postgres to use my ...
1
vote
1answer
20 views

MySQL datetime to just date

Currently I have a table containing a column of type datetime. I have no need for the use of the HH:MM:SS that trail the variables stored in this column. I just need the YYYY-MM-DD. Is there any way ...
3
votes
0answers
20 views

File size when extracting from SQL Server to CSV

I am attempting to extract a table to CSV using BCP from SQL Server 2014 and the size of the file once the data is extracted is actually larger than the size of the database itself. One thing to note ...
0
votes
1answer
30 views

Query distinct emails not logged in within a period of time

I need help in writing a query to return distinct emails that have not logged into ABC database in the past 5 months. The exact task I have been asked is as following: Create a table in ABC ...
0
votes
2answers
17 views

Quick and easy ways to check SQL/DB performance [on hold]

We host a web application for customers, sometimes they call in and complain of slowness. I was asked to have a list of things to check from network down to the application. For SQL, can any suggest ...
3
votes
1answer
22 views

What normal forms are these two relations in?

I have a set of relations {A, X, Y, Z}: Given that the functional dependencies: AX→Y, AX→Z, Y→A, Z→X, I would think that this relation would be in the normal form 1NF, because there is a partial ...
1
vote
0answers
7 views

How to restore SQL Server database from Azure Blob?

I created a database (IaaS) from Azure marketplace (Windows server 2012 + SQL Server Web 2014). I Selected automatic backups to blob storage. Now I'm trying to do a test restore operation. I imported ...
0
votes
1answer
23 views

ORA-00932 on subquery join from subquery join

The only guess I have is that perhaps the size of the subquery is considered a CLOB? I have no null values for the fields selected AFAIK. SELECT DISTINCT kbq_ent.qid AS kbq_ent_qid, ...
0
votes
0answers
12 views

MySQL 5.6 performance_schema not showing queries from application

I'm seeing a strange problem with perfromance_schema... it seems queries are not getting logged as I expect them to be. For example, this is what I get: mysql> SELECT `SCHEMA_NAME`, `DIGEST_TEXT`, ...
5
votes
1answer
58 views

Transposing hierachical data from one VARCHAR to two INTs

THE PROBLEM The table where the data is recorded is CREATE TABLE [dbo].[Almoxarifado]( [idAlmoxarifado] [varchar](20) NOT NULL, [tipoAlmoxarifadoId] [varchar](30) NOT NULL, [entidadeId] ...
1
vote
0answers
14 views

Expose SSRS Reports in websites

I'm fairly new to the SQL Server stack, and am trying to wrap my head around how to best expose on-premise SSRS reports in websites (LAMP stack). URL Access appears to be what I'm after, as it lets ...
0
votes
0answers
26 views

Foreign keys not trusted but they were not disabled

Is there any other way that a foreign key would be marked as "is_not_trusted" besides disabling them and re enabling them incorrectly? They were created without the NOCHECK option initially (meaning ...
1
vote
0answers
21 views

Justified multi-value field in MySQL?

I have a table of data that contains 10 point values based on a score for an event (0 - 9 points). If a time is within the range, the point is awarded. There are 20 possible events. Is this a valid ...
0
votes
0answers
13 views

Dependency preserving decomposition

Let be the following relational scheme: F={AB → C; AC → B; AD → E; B → D; BC → A;E → G} Is the following decomposition without loss of dependency? ...
0
votes
2answers
28 views

Update field in SQL Server Table Dynamicaly

I need to do a 1 time update of a Sql Server table. The table has a unique ID, contains a member number field and a FileName field which tells us what file the member data came from. What I am ...
5
votes
1answer
133 views

Concatenation, with separators, where any combo of input fields might be null

I have three columns, CITY, STATE, COUNTRY. One, two, or all columns may be NULL. With the following logic, a single string is made using the SQL below. It is messy, and I am wondering if there is a ...
1
vote
0answers
19 views

How can I “buffered” mine Oracle logs using LogMiner with 'committed data only' option properly?

Using Oracle LogMiner with committed data only flag, According to the Oracle documentation, all the committed records with the same commit scn, will be joined together and will appear in a sequence. ...
0
votes
1answer
50 views

Locking in Stored Procedures [on hold]

If a stored procedure has multiple statements,will the lock acquired for the first statement be released once its executed or will it hold on till entire SP is complete? I am running an SP under ...
2
votes
0answers
24 views

Does Trace Flag 8295 applies to SQL Server 2012?

I've been searching about the undocumented Trace Flag 8295. It's been introduced with KB 2476322 in SQL Server 2008 and "'Creates a secondary index on the identifying columns on the change tracking ...
0
votes
1answer
36 views

comparing left join and outer apply doing the same thing

I have an update trigger on a table that that insert rows in another database/table the query look like insert into otherdb.table select manyfield from inserted left join (select id, ...
0
votes
0answers
9 views

Mongodb cluster deployment

I am new in mongodb and I am trying to deploy a mongodb cluster and I am following: https://docs.mongodb.org/manual/tutorial/deploy-shard-cluster/ I initiated Config Server Replica Set and after ...
-4
votes
0answers
23 views

Query for columns

I need help writing a query. I have a table named "schedule", with columns "start time" and "end time", both with the time data type. Student have today discipline "Networks" from 11:00 (in start ...
0
votes
0answers
20 views

subscriber table needs to be updated - how to use a batch process AND how not to upset the replication while doing it?

I have a table called tblBOrderPaymentGiftVoucher that is replicated to 3 different subscriber servers. this table is part of a publication that contains many tables, some very big. I can't afford to ...
0
votes
1answer
32 views

How to declare reserved words as variables in Oracle PL/SQL?

What is the best way to bypass the Oracle SQL reserved-word constraint for PL/SQL value declaration? I realize bind and substitution may be acceptable alternatives for an actual query, but what about ...

15 30 50 per page