1
vote
1answer
42 views

Oracle 12c client installer error

I'm trying to install Oracle client 12.1.0.2.0 (32-bit) on a completely clean copy of windows Server 2012, and I'm hitting a problem. The installer runs fine until it gets to the final part - the net ...
0
votes
0answers
14 views

INSERT DATA The database disk image is malformed

We use sqllite to store our data. Today,when I wanted to insert data in sqllite db,the log showed The database disk image is malformed
0
votes
0answers
27 views

Export MySQL Database with version compatibility

I'm trying to move a MySQL database out of my Win 2012 server & onto a shared hosting web server (Linux). I'm having problems importing the database (which imports fine into other hosted packages ...
2
votes
2answers
106 views

Mixed SQL Server instances with static and dynamic ports

Let's assume someone has 5 different SQL Server instances running on a server. Initially all are using dynamic ports. Is it safe to restrict one of those instances to use the static port 1433 while ...
0
votes
0answers
31 views

ERD diagram for online ticket reservation system [on hold]

Simply, the problem is about to create sale and reservation system for bus transport company. The biggest challenge is to design database that it will be prepared to situation like this: The bus ...
0
votes
0answers
28 views

Starting the Database Server postgres [on hold]

OS X 10.10, postgres 9.3.5, installed from here I had to initialize the datacluster manually, as stated on the site, through $ /usr/local/pgsql/bin/initdb -U postgres \ That worked fine. At the ...
0
votes
1answer
27 views

SSRS email Subscription Not Working but local smtp is working

SQL SERVER EDITION- 2008 ENTERPRISE EVALUATION EDITION Operating System- Window Server 2008 R2 I've Created Local Smtp to use gmail id for Subscription of SSRS Report by Email as we don't have an ...
0
votes
3answers
80 views

Which of these database designs is normalized?

I have two possible database designs. A) a many-to-many relationship between Branches and FiscalYears via a dedicated join table FiscalYearsBranches B) two (or more) many-to-many relationships ...
0
votes
0answers
17 views

Unable to point out Exact cause behind anonymous block failure(Postgresql) [closed]

DO $$ DECLARE customer_list varchar[]; customer_schema varchar(100); BEGIN customer_list=ARRAY(select cname from customer); -- Get a ...
0
votes
1answer
14 views

Run MySQL replication by schedule or on demand

I have a master-slave replication currently configured. I know this setup runs real time. Is it possible to sync only the databases on schedule (daily or weekly) or by demand? Thanks!
-4
votes
2answers
47 views

About Criteria in T-SQL Statement [closed]

Today the code is: select * from datatable where id is not null However, if I want to retrieve data of id I want to add another criteria in where statement I'm trying to improve the code below ...
1
vote
0answers
14 views

When to include and exclude products from a webshop database? [closed]

I'm working for a company that runs a webshop and integrates around 15-20 different merchants. In the database schema for the actual website/webshop (Rails with postgres SQL), products are only ...
0
votes
0answers
11 views

how to export mysql database in xammp [closed]

I was getting error massage to export mysql database in xammp so please give me the address .i tried but can't access the export file in database on phpmyadmin
0
votes
2answers
19 views

Unable to delete Log Shipping configuration

I need some help with my SQL 2005 server. I am trying to setup log shipping, I've successfully done so for all user-databases, except one. From the looks of it, it once had log shipping configured ...
0
votes
0answers
9 views

Is it possible to import a CSV file into MySQL using VB.Net? [migrated]

I would like to know if it's possible to use LOAD DATA LOCAL INFILE via VB.net to import a CSV given a path to the CSV.
1
vote
0answers
26 views

Database Engine Services status failed

Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL ...
1
vote
1answer
17 views

Oracle: How to get a list of CTXSYS.CONTEXT indices?

I can get a list of indices by querying USER_OBJECTS. How can I distinguish which of these indices are of type CXTSYS.CONTEXT?
1
vote
1answer
35 views

Migration from SQL Server 2012 Ent to SQL Server 2014 STD

We recently migrated from a traditional hosting environment with a back end of SQL Server 2012 ENT to an Azure VM running SQL Server 2014 STD. We did all the cool stuff with BPEs on SSD, etc. The ...
0
votes
0answers
37 views

Why does a table take more space in SQL server than in Teradata?

Is there any reason for a table to occupy significantly more space in SQL server than Teradata? The rows and data structure (columns, data types, data type length) are same, no extra objects like ...
0
votes
0answers
34 views

MSSQL Query table returned all rows but keep executing for long time

After database migration to a new server, my web application got many timeouts on particular table, I suspect there is some problem with the table. When I simply try a small table (of 3 thousand ...
1
vote
1answer
9 views

How to set user-level security in 2007+ MS Access?

I've read this MS info which should cover my problem. There are quite clear steps: Open the .mdb or .mde file that you want to help protect. On the Database Tools tab, in the Administer ...
0
votes
1answer
14 views

Use a value for a Postgresql setting in a trigger

We're using a trigger to track changes in various database tables. This works fine. Now we want to be able to track the changes back to the web request that caused them. I'd like to be able to use ...
5
votes
0answers
62 views

SQL Server - Best practices on debugging extremely complex stored procedures [closed]

I recently inherited a MESS of a search. It's around 10,000 lines of code in the procs/functions alone. This search is aptly named the "Standard Search." It's a proc that calls about 6 other procs, ...
2
votes
1answer
67 views

How to write a query, with multiple foreign key in mysql

I am working on a simple PHP and MySQL college level clinic management system. There 4 main table which relation with foreign key. I'm little bit confusing multiple foreign key in table .. what would ...
1
vote
3answers
15 views

Optimizing MySQL query with left joins

Ok, so first off i am going to provide a bit of information on the database structure I have 3 indexed tables that are used in this query (though one of them should probably be a weak entity, but ...
5
votes
1answer
34 views

Moving TDE database to a new database but having problems with the cert

This is my first time working with TDE so hopefully I haven't done anything horribly wrong. I'm trying to move my TDE database from one server to another. I have created a master key on the master ...
1
vote
2answers
52 views

How to pull number code from strings buried in parentheses?

I have string data (ProductDescription) that includes product names and ID numbers and need to pull the ID numbers for cross-referencing... Data Samples: Widget (1234) Different Widget (123) Many ...
0
votes
0answers
10 views

Print to console as SQL executes

When executing multiple SQL commands, such as in the pgAdmin SQL Editor, how can I print some strings to the console (output pane in pgAdmin). I want to monitor execution. UPDATE x SET a = b WHERE a ...
-1
votes
1answer
31 views

Oracle Alter table add partition by reference gives “invalid datatype” error but create table with partition works

I have a parent and child tables. Parent table has a partition and a sub partition. Child table needs to have reference partition based on parent partition. Problem: If I create a new child table and ...
0
votes
1answer
19 views
+50

Installing Oracle Forms and Reports on a 64bit machine

I'm trying to install Oracle Forms and Reports on a new server 64 bit (Ubuntu Trusty Tahr). (I'm only actually interested in the report server component). I can't find a version that I can install ...
0
votes
1answer
13 views

How do I get the some of the values from 2 foreign keys in a table?

I've spent a good amount of time on this but, still have no idea as to the sql query I can use to get the student name, and class name from the payments_per_student table. edit: This using JPA work ...
1
vote
1answer
25 views

Optimize view (and underlying table) for averaging timestamps into hours

I have this table: CREATE TABLE spp.rtprices ( "interval" timestamp without time zone NOT NULL, rtlmp numeric(12,6), rtmcc numeric(12,6), rtmcl numeric(12,6), node_id integer NOT NULL, ...
0
votes
1answer
43 views

Select Multiple Values from Same Column; one sql statment and split into separate columns

This post derives from following - Select Multiple Values from Same Column; one sql statment Based on this query - SELECT user_id,GROUP_CONCAT(meta_value ORDER BY id) FROM t WHERE meta_key ...
0
votes
0answers
33 views

Tuning a Postgres INSERT only database

I am designing a database which will have many inserts and selects, but no updates. Are there any considerations to take (in order to have high query performance) while knowing no tuple updates will ...
1
vote
3answers
45 views

SQL self join with condition

I have table like: bu_id bu_name parent_id 1 DefaultBU NULL 601 bu1 1 602 bu2 601 603 bu3 NULL 604 bu4 603 I want to retrieve the ...
-2
votes
1answer
34 views

Usage of COALESCE? [closed]

Today: table abc a b c d ---- ---- ---- ---- 1 null 2 3 null null null 7 null 5 null 4 1 = e 7 = b 5 = f 3 = i 2 = w 4 = o The Goal is to retrieve this ...
0
votes
0answers
19 views

Design Payment System - Best way to track different payment types and reasons

I am designing a system to track incoming payments from external entities. Payments will be stored on tblPayment and take place in different ways, to mention some: 1) cash 2) cheque 3) credit ...
1
vote
1answer
40 views

CheckDB error 9003 SQL server 2014

Currently I am restoring SAN snapshots to another server nightly and running weekly checkdbs on that test server. The checkdb is throwing the following errors. The log scan number (105217:402:0) ...
1
vote
3answers
66 views

Can you Schedule a job inside another job?

I have many jobs that need to run but they cant run at the same time. the first step of each checks to see if any others are running if yes it waits a little bit and checks again. This can lead to a ...
0
votes
0answers
5 views

Enter-PSSession Slow responsiveness [closed]

Once I have connected to a host using Enter-PSSession I see slowness with the shell overall. enter-possession -cn hostname any ideas as to how I can fix this?
0
votes
0answers
16 views

Require distributed transactions for server-to-server communication

I want to know limitations or disadvantages of enabling 'Require distributed transactions for server-to-server communication' on SQL SERVER 2012 please? My SQL database Server 2012 have a subscriber ...
0
votes
0answers
12 views

Transaction block on coordinator

I tried to commad a procedure described here: http://files.postgres-xl.org/documentation/add-node-datanode.html We went as far as the third step, and everything was going perfect, but during the ...
1
vote
1answer
18 views

“Remote” connection to a local MYSQL database on LAN

I have a mySQL (5.5.38) server running on my desktop (windows 7), I can connect just fine into any of the servers Users, and skip-networking is off when checked via show variables. I am trying to give ...
1
vote
2answers
49 views

Unable to restore database backup becouse it is accessed by other connection

--first command use master Go -- second command ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE Go -- Third command RESTORE DATABASE [MyDB] FROM DISK = ...
0
votes
1answer
18 views

SQL Server Express 2008 R2 Configuration Manager How To Find It

I run Windows 8.1. I installed SQL Express 2008 R2 over a year ago, but now need to access it from another machine. My problem is that the Configuration Manager (SQLServerManage10.msc) is not on my ...
0
votes
1answer
13 views

how to give access to view only one database to a particular users in sql server 2008

I need to give 5 different users to access one database, hiding other databases. I have tired to give access, i am able to give only one user not for all.
0
votes
1answer
35 views

Migrate Jira to MySql - Unknown system variable 'storage_engine'

I'm migrating JIRA in Windows from HSQL to MySQL and I got stuck with the message Unknown system variable 'storage_engine'. Though I created a backup, installed MySQL and copied J connector to libs ...
0
votes
2answers
14 views

Install DBeaver SQLite driver offline?

I'd like to use DBeaver with SQLite, but the network firewall disallows external connections. So DBeaver cannot download the driver automatically. Where can I download the SQLite driver for it and ...
2
votes
2answers
117 views

What is the recommended method to move databases?

I want to know the recommended method to move a database and data from dev to pre-prod to production in SQL Server. The databases are originally created in MS Access so some upsizing to SQL Server ...
0
votes
1answer
30 views

Options for structuring multiple associations to a record

This is 101 level stuff and I promise to read a book later, but in the meantime, given the following three tables: Product --------- ProductId (uniqueidentifier) User --------- UserId ...

15 30 50 per page