A collection of data that is usually organized into tables for different data objects. Tables usually consists of records on instances of the data objects.

learn more… | top users | synonyms (2)

-1
votes
0answers
46 views

Suggestions for Staging table for XML ETL? [on hold]

Suggestions for Staging table for XML ETL? Thanks for responding to my threads and looking into this issue. We have a large XML message file. We want to extract the data from this XML file and load ...
0
votes
0answers
2 views

Same Excel workbook fails to connect to Access DB for SOME users

I have an Excel workbook that is pretty heavy with code and connections to Microsoft Access. When the Workbook opens, it looks at the database's full path, written in a cell in the Settings sheet. ...
0
votes
3answers
3k views

How may I retrieve data from an Excel table based on a variable number of criteria?

I have the following salary data for example: Country State 2012 2013 -> 2027 ======= ===== ==== ==== China Other 1000 1100 China Shanghai 1310 1400 China Tianjin ...
1
vote
0answers
5 views

Format sqlite3 .schema command output

I created some sqlite tables schema using python. When I use the sqlite3 client and issue the .schema command, I can see the output is pre-formated as in the SQL source file I used as argument for the ...
4
votes
3answers
2k views

To have Vim Psql's editor

I have a Fresh Ubuntu installation. I have no personal dot-files active. I run unsuccessfully \e file.sql in Psql, when I have the following in my .bashrc, since Nano opens instead of Vim export ...
-2
votes
2answers
30 views

How to connect multiple websites to one database in same server

What would you do if you have one server and multiple websites in that server and you want to connect all of the websites to one MySQL database in the server? I know it decreases the security but I ...
0
votes
1answer
13 views

Exchange Server DAG and Failover Cluster with High Availability

I have 2 exchange servers (EXCH1 and EXCH2) that have Exchange 2013 on them. They are both on Windows Server 2012 R2 (Standard) machines. They are also a part of a DAG (Database Availability Group) (...
3
votes
2answers
3k views

Can I use SQL to build an Excel data table from other Excel files?

I know SQL well enough to perform basic queries and manipulate data split into multiple tables in a database. I know Excel 2007 a bit better and use it frequently to manage my mechanical engineering ...
0
votes
1answer
22 views

Synchronizing database between local and remote machines

This may be a popular question, But i am new to synchronization concept. Please guide me with suggestions. My requirement is to have a local and remote database(cloud) to sync the data between them. ...
-1
votes
0answers
12 views

Quandl, How to pull data from Quandl using API

Does anyone have any thoughts on how to pull data from Quandl into a simple database, so that I can run a query or group of queries against that database to pull the information I need? For Example. ...
0
votes
2answers
477 views

#126 - Incorrect key file for table '.\mysql\db.MYI'; try to repair it

I posted my question on serverfault but they hold my question by advising to post it in SuperUser I installed Xampp and can see localhost page as well as both apache and mySQL is starting fine but ...
0
votes
0answers
22 views

MySql 5.6 - windows 8.1 can't access or copy ibdata1 file after force restart - cannot restart MYSQL

I'm having a serious problem with my MySQL server and my ibdata1 file. I had for force restart my development machine - as result I cannot restart my MYSQL server. When I restart my MySQL server - ...
1
vote
4answers
864 views

this database is not compatible with this application - Application compatibility toolkit

I installed the Windows Application Compatibility Toolkit and installed SQL server 2012 express to use as the database server. When I run ACT and try to create or select a database, it puts a little ...
1
vote
1answer
64 views

MySQL error, can no longer login as root

So I updated my MySQL and PHPMyAdmin yesterday and ever since then I cannot login to MySQL as root or any other username I have. I tried both phpmyadmin and the terminal and still cannot get in. How ...
1
vote
1answer
99 views

Horrendous decrease in MySQL Performance after upgrade to Ubuntu 16.04 MySQL 5.7.12

I have a development server that I recently upgraded from 14.04 to 16.04. I have a database 'algebra', which hosts data for my website algebra.com. It is a Q&A website that has Questions and ...
-3
votes
0answers
22 views

How to take inputs and create database in excel

I apologize in advance for the broad question. I am using excel to keep a database of a group of around 20 people and (theoretically an infinite amount) of companies for a school club. Basically, I ...
0
votes
1answer
7k views

Creating user with password or changing password doesn't work in PostgresQL

I'm trying to create a new user role or change existing one's password to be able to work locally with PostgresQL. I'm working on Ubuntu. I can modify the attributes of an user, but for some reason ...
-2
votes
1answer
21 views

Excel - Manage database to import to CRM

I have a database where each row contains a variety of company info (name, address, website, phone, etc. Each row also contains three contacts and their corresponding title. The headers are CEO Name,...
3
votes
2answers
28 views

SQL : Restrict view of tables in database

This is probably a no but, I want to be sure. A client wants to connect to SQL Server 2008 that we host. They will be accessing a table to execute an SSIS package to copy some data they have on their ...
0
votes
1answer
28 views

How to convert 3 colum in an excel matrix?

I have many data set on 3 column as the tab above and I would like to convert to a like the one in the picture. Is there a function that do this in MS-excel 2007? I think I need to create a ...
1
vote
1answer
62 views

What embedded database format is used by this Chrome extension?

Chrome extension F.B. Purity writes its data at ~/.config/chromium/Default/Local Extension Settings/ncdlagniojmheiklojdcpdaeepochckl/000003.log (not a log file despite its name). This file is a kind ...
0
votes
0answers
6 views

sql server 2000 vs 2014 local login

I have an application written in delphi AND uses sql server 2000 as database engine.I was on windows server 2003 for many years without problem.recently I upgraded to windows server 2012 r2 and sql ...
1
vote
0answers
198 views

Importing data from database into Excel Web Services with parametres

I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...
3
votes
2answers
28k views

Dynamically filtering data before importing from SQL Server in Excel

I'm trying to figure out whether there is a way to filter the data from an SQL Server connection before it is imported into Excel. The initial import doesn't matter (when the connection is set up), ...
1
vote
2answers
2k views

Why would “database properties” suddenly fail to do anything?

I'm using Visio 2007 Profession SP2 on Windows 7 Enterprise x64. I have a rather complex ER database diagram I've been working on a few weeks. It does use some non-ER shapes for callouts and notes. It'...
0
votes
0answers
43 views

RPM-GPG-KEY Error While Installing Oracle Database 11gr2 on CENTOS 7

I am Trying to install Oracle Database 11gr2 in CENTOS 7.For installation process I am following this procedure https://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-7 ...
2
votes
1answer
21 views

In Microsoft SQL Server, how can I disable “X rows affected” at the end of my output?

I'm querying a database in Microsoft SQL Server and writing the output to a csv file. When importing the outputdata into another program i get an error because the last line of my output file ...
0
votes
0answers
8 views

Self-creation of odd database files?

Quark 11 has just created two files and they now appear in my 'open recent' list. One is called 'link', one is called 'ls'. Neither can be opened by this version of Quark, both are locked. I don't ...
0
votes
1answer
5k views

Sybase: how to add a connection definition to ASE isql?

My knowledge of using sybase on windows is getting rusty... I want to use the open source isql tool ASE isql. When I tried to establish a connection to my sybase database, a 'Connection' dialog box ...
0
votes
2answers
134 views

How to move postgresql database from one computer to another?

I've been created an Internet service on Debian server. I want to move all data from one server to a new one. So, how can I move the postresql database? What is the best pipeline?
3
votes
2answers
2k views

How can I keep every fifth row in Excel

I have a data set in excel with 3084 rows. I need to delete 4 rows, then keep one: deleting Tuesday, Wednesday, Thursday, Friday but keeping Monday to create a weekly rather than daily data set. ...
-1
votes
1answer
24 views

How to automate a database search on a website from a third party website?

My users will be uploading products on my website which are registered by a government organisation. This government organisation has created an online database of these products which is free to ...
0
votes
2answers
326 views

How to determine sql server name

I'm trying to install sap business one on my computer. But I can't seem to connect to the database server which is ms sql. I get the notice: unable to connect to the database server name, and that ...
0
votes
0answers
23 views

15 MB SQLite database file from Chrome history shown blank

I accidentally removed the profile from my Chrome on Windows and everything disappeared. Except I was able to recover 15 MB history file from my hard drive it said the file was not corrupted. But ...
1
vote
0answers
14 views

Database: AOC (intersection-based) efficient 3-way join?

I am attempting to improve performance on a highly normalized database wherein I have the following structure. entity (identity) org (identity) entity-org relation (many to many) org-entity-owner-...
0
votes
0answers
28 views

Classic .ASP and OnChange and reading an Access database (WIN10)

I'm trying to populate the contents of a web form with an Onchange header function (select * in database where ID="somevalue") but I don't know how to open the database whilst in the header function ...
0
votes
0answers
13 views

Query optimization in Data stream

I am confused about the idea of query optimization in stream of data. As a background, I know that optimization for any query is happening inside the DBMS with using of system catalogs which contain ...
1
vote
1answer
994 views

mysqldump not on wamp server

I am trying to use mysqldump on my wamp server mysql console however, it doesn't seem to have mysqldump included. I found the mysqldump.exe file in this location: /cygdrive/c/wamp/bin/mysql/mysql5.6....
0
votes
0answers
91 views

TortoiseSVN database locking errors after disabling Samsung RAPID mode

One of my users is getting database lock errors from TortoiseSVN after disabling Samsung RAPID mode. What's a good way to find out what programs had a file locked recently? Since it requires a ...
29
votes
5answers
30k views

“FATAL: lock file ”postmaster.pid“ already exists”

I just reinstalled postgres via brew install postgres I ran initdb /usr/local/var/postgres -E utf8 but got this: The files belonging to this database system will be owned by user "atal421". This ...
0
votes
0answers
44 views

SQL Server 2014 Express has reached database size limit. What is the quickest solution?

My SQL Server 2014 Express database has reached database size limit. What is the quickest solution to get back up and running? Is Express software the same as the full version, with just some ...
0
votes
1answer
61 views

Hardwareinventory - Copy Record with values in Access 2016 Web App

I want to make a WebApp in Access which help me inventory all our Hardware. Below is a VERY wip ERM for the Database behind it. Every CPU-Object is its owm physical thing (if we have 2x i5-3450 there ...
0
votes
1answer
81 views

Excel Pivot Table with Microsoft Access Connection

I have a pivot table which sources its data from a query within an Access database file. Whenever I make an update, I make a copy of both the Excel and Access files first - and carry out the update on ...
1
vote
1answer
203 views

How do I find out what my SQL Server database audit records contain?

I need to find out if my SQL Server 2005 database audit records contain the required information that I need. Where or how can I find this out?
1
vote
2answers
7k views

How can I remove Postgres completely from my Mac?

I have been experiencing spooky behavior with Postgres after using the Mac installer for Postgres. There seems to be an existing half-baked Postgres installation that was already there and remains ...
2
votes
2answers
36 views

Which wildcards can I use for a Microsoft Access form asking for month and year?

I made an Access Database that includes dates. I have a Report connected to a query that, when opened, prompts the user for a month in numbers (1-12) in order to produce the report for that months. ...
0
votes
3answers
4k views

Linux Mint (Ubuntu) Microsoft Access Replacement? [closed]

I've just switched over from Window to Linux Mint, and the only thing I'm missing is a replacement for Microsoft Access. I'm aware of LibreOffice (which comes installed), are there any others I ...
0
votes
2answers
40 views

Excel 2016 list of options for connection to DB has suddenly reduced, (MySQL, PostgreSQL)

I work with open source dbs such as MySQL or PostgreSQL as a back-end data storage with my excel 2016. I had the full list of connections to all different kinds of dbs but they are suddenly reduced ...
1
vote
1answer
83 views

Back end already in use

We are using an Access Database divided in front end and back end (in a shared folder). I distributed copies of the front end to every user. All users have the shared folder and subfolders added to ...
3
votes
2answers
4k views

Incremental Backup for PostgreSQL 8.3

I'm looking for a way to make good incremental backups for a large (more than 100 GB) PostgreSQL 8.3 DB. I'm currently using pg_dump which isn't incremental and very slow in backup and restore, ...