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)

0
votes
1answer
8 views

Photo Organizer that works from many computers to one file server

I have a file server in the closet. It runs Ubuntu, and exports my photo library as NFS4 and SMB. I have children and a wife who all also want access to these photos. Right now, the archive has the ...
-2
votes
0answers
13 views

How to Move/Recover Data in Microsoft Exchange 2007

Looking how to Move and Restore corrupted EDB Data of Microsoft Exchange. Is it possible?
0
votes
0answers
12 views

generate entity relationship diagram from h2 database

is there an easy way to generate entity relationship diagram from h2 database? I coudn't find any useful thing from google.
0
votes
1answer
10 views

MS-Access many to many relationship with subform having multiple criteria

In my database design there are 5 tables and i want my database to be able to save the course fee given by student. according to the design one student can enroll in many courses. i want to ...
-1
votes
0answers
19 views

Missing MySQL Database after Windows Upgrade

First of all, please bear with me as I am quite new to HeidiSQL, MySQL, and the concept of relational databases as a whole. I recently started using HeidiSQL in order to create tables for import into ...
0
votes
1answer
26 views

Are Intel i7 core mobile processors decent enough for software development? [on hold]

I'm reaching out because I'm in the market for a new laptop, and I would like something light that I can take with me for a job interview or meet clients, so I can demonstrate my source code and ...
0
votes
0answers
17 views

Recover back end database password from front end connection string

I built an MS Access database about a year ago and set separate passwords for the "front end" and "back end" components of the database. It's been a long time since I've had to access the back end ...
3
votes
1answer
34 views

SFTP transfer a file from server to desktop

I am trying to compete an assignment for school and I have one final step. I have use the "put" command to load the file. Then ran a spool and the file followed by ending the spool. Now I am back at ...
1
vote
0answers
15 views

Database-based word document

I will take an example, it'll be easier: So I have a database about classrooms. There is student db which contains all the students like so: id name surname slug class 0 John ...
0
votes
0answers
15 views

Barnyard - Database Warning

I installed snort and barnyard. When I start snort and barnyard services, barnyard could read snort.log file but it doesn't write to mysql database. So I run tail -100 /var/log/messages and I ...
0
votes
0answers
10 views

SSDT compare dacpac and db solution

I have a question related to the compare of the db solution and a dacpac, I'm using SqlPackage.exe for the comparison but when I have the result I saw that in the comparison was included all the ...
0
votes
0answers
27 views

Barnyard Service - MySQL Error

I installed barnyard2 and saved as a service. When I run service barnyard2 start, Barnyard2 is failed. After I run tail -100 /var/log/messages and I encounter a fault like this. ERROR database: ...
0
votes
0answers
23 views

Is there a tool for syncing changes to individual nodes within HDF5 files?

I'm looking for a tool for efficiently syncing large scientific datasets in HDF5 format: Each file is ~20-30GB in size and contains many large floating point arrays, which are usually chunked and ...
1
vote
0answers
32 views

Getting Excel to “update” or “follow” a linked Access table?

I'm using Excel and Access 2007. I'm having an issue at work and my current knowledge of Access and Excel isn't enough. I have an Access database that has certain data in it. I have an Excel ...
0
votes
0answers
8 views

Oracle RAC 11G Requirements VS Single Node 11G

I have an Oracle 11G Database running on Solaris SPARC. I'm already using NFS for the node. I'm looking at moving to RAC. Would there be any additional requirements for RAC besides an additional ...
0
votes
0answers
15 views

2010 Microsoft Access Relational Table Insert

I am working with a Microsoft Access 2010 database with 3 tables. What I want to do is edit the 3rd table (Street) and be able to call information via combo boxes from City and State. When I add a row ...
0
votes
1answer
59 views

How do I create & restore a mysql database dump with Chef?

Environment Ubuntu 12.04 Precise64 Enterprise Chef opscode-cookbooks/mysql opscode-cookbooks/database Wordpress 3.9 Objective I am trying to replicate/clone my production Wordpress server. I'd ...
0
votes
0answers
4 views

Unable to restore testcase database of quality center 9.2

We are using quality center 9.2 for storing test cases. Recently the Quality center server had some issues, so we took back up of entire C drive and formatted the PC and installed OS newly. Now we ...
0
votes
0answers
32 views

MS Access .mdb & .ldb database corrupted

I am using a A.mdb database. You know when connecting the databae Microsoft automatically create a .ldb file. Unfortunately my pc shutdown when connecting the database. As a resutl after restart the ...
3
votes
3answers
88 views

How to split one row in Excel into multiple rows for database management

I have a set of data that is currently 39,000 rows and 27 columns. The first column is the ID number. The subsequent columns correspond to elections, with the date of the election in row 1 (cells ...
0
votes
0answers
9 views

Are there any NULL bytes in an MS Access database?

Mercurial diffs files only if it is "not binary", where "binary" is defined as "contains a NULL byte". Do databases in MS Access (.mdb) contain null bytes?
0
votes
0answers
10 views

Personal queryable address book with document management

Please suggest me any freeware software or cloud solutions that allows: Create and manage a person date (like in address book) Attach any documents to the persons Query the system, e.g. to select ...
0
votes
0answers
36 views

Auto-Fill Textfields in PDF from external sites?

So I've got an editable PDF with 2 text fields. Name and EMail. The PDF is locally as in on my current PC. The database is remote, and has 2 fields called "Name" and "EMail". However it is not a ...
0
votes
2answers
48 views

Pulling out data from a spreadsheet

I need to add information of clients who have visited the office, which department, who they were referred by, who they were referred to etc. I have linked a screenshot of what I have currently made ...
0
votes
0answers
37 views

SQL database recovery from corrupt database file. What to do next?

Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental ...
0
votes
1answer
49 views

mysql backup verification

Im not a dabase admin or advanced database user or advanced linux user.. but I would like to know how to verify mysql dumps because I am backing up my own sites manually. Normally when backing up lot ...
0
votes
0answers
26 views

How to create installer for my visual basic project with sql server 2008 database?

Hi guys I have a visual basic project and I developed it using visual studio 2010 and sql server 2008 for my database. Now, I want to make an installer that will include my sql server database. I ...
3
votes
1answer
39 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
-1
votes
1answer
81 views

getting error in mysql— #1064 error while creating trigger

I need to create a trigger for a table called try.. which will execute after something is entered into the table..(I am using phpmyadmin mysql) But i am getting #1064 error while creating it.. My ...
0
votes
1answer
38 views

Access Database design when changing course fee after certain period of time

I currently have three tables: student id (pk) , name course id (pk) , course_name , course_duration , course_fee student_course student_course_id (pk) , student_id (fk) ...
0
votes
2answers
100 views

How do I connect to some local DB server in MS SQL Server 2012?

I installed MS SQL Server and now want to create some tables and do some queries ... I need to have some local DB Server running to do that right? When I installed SQL Server there was no option to ...
1
vote
1answer
74 views

how do I alter the structure of a table in SugarCRM CE?

How do I add fields to the opportunities table so that they propagate? From within Studio > Opportunities > Fields I added fields. Pardon, I don't understand the next step to effect a change ...
0
votes
1answer
26 views

How to create a database from psql user (not linux user)

I' ve studied some PostgreSQL. In the principle i' ve been teach to create a postgress's user with same name of my linux's user. Now i want to try to make an application, and for this reason i would ...
0
votes
1answer
51 views

Transactions per second in a database (say PostgreSQL)

I refer to 2 documentation pages on PostgreSQL's site: #1 and #2. From these, we see the transaction log is flushed to disk 5 times per second (wal_writer_delay = 200ms), and we also see the RDBMS ...
0
votes
3answers
74 views

I'd like to create a database of pictures. Where to begin? [closed]

I'd like to create a searchable database of images. I'd like something a little expandable, meaning I'd like to define my own fields and be able to search on them, but I'd also like to be able to ...
0
votes
1answer
116 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 ...
-5
votes
2answers
199 views

How do I convert a .csv file to a database?

I have an 8GB .csv file with 6 columns and 202,176,000 rows. How would I convert that to an OpenOffice database(.db) file?
0
votes
1answer
368 views

Installing Oracle 12c on CentOs 6.4

I need to install Oracle DB 12c on Centos 6.5/6.4 that has no GUI (or xserver) installed, Is there a way to do it? Can you point me to a manual? Thanks
0
votes
1answer
43 views

Strategy for Incremental Datasource fetchings in Excel

I am in an scenario with a table that is refresh by a third app every week. I need to keep accumulating all data in Excel, using an ODBC connection to the database. I am wondering Approach 1: Is ...
0
votes
1answer
31 views

Pull Couchbase database over ssh from remote server

I am working on a Debian environment and I have to pull a Couchbase database from a remote server location into my local Dev environment. I wasn't able to find any kind of details on this topic so ...
2
votes
1answer
83 views

Should I install SQL Server on a SSD drive (educational purposes only)?

I have just started using a 120 GB SSD drive on my laptop. I wonder if it is a good idea to install SQL-Server on this partition. I am sure I will want to install Management Studio there but what ...
1
vote
1answer
45 views

Oracle database block diagram or map

I have an Oracle database. It has multiple schemas, and each schema has many tables. Is there a way to generate a tree diagram or block diagram, such as this image, to visualize the database? I ...
2
votes
1answer
60 views

How can I sync Access databases and keep them up-to-date?

I have an Access database on my server. We split it up and use the front-end database for search data and adding new records or reports in local computer. If we update or add a new record, that writes ...
1
vote
2answers
76 views

Is there such thing as a portable database that runs easily OsX and Windows?

I need to make a small database for a project at school (not computer related at all, I'm indexing and categorizing paper documents of a research projet). The thing is that in september, my semester ...
0
votes
0answers
107 views

Use Excel to query Sybase database

Excel offers the ability to connect to external data sources. I am told I can connect to a Sybase database to import some data into excel from a query. How do I do this? I have the following: Query ...
0
votes
0answers
11 views

Inline images in RTF Memo field or other methods for dealing with inline graphics in MS Access

I want to use Access to organize some testing information. I will have normal data fields, but I need some type of way of having text combined with images stored in a memo field. I have already ...
0
votes
0answers
15 views

how to set default data type for create table in dbvisualizer

I am creating a postgresql database in DBVisualizer. Things would go faster if I could gain control over the default data type I get when I create a column. For Postgresql, it defaults to bigint and ...
0
votes
0answers
47 views

Access database shows as read-only on one workstation (unless logging in with domain admin privileges)

We have an Access database stored on a central server on our LAN, accessed by 20 domain-joined PCs (15x Windows 7, 5x XP). For some reason, one of our XP workstations only allows users to access the ...
1
vote
0answers
49 views

SQLite GUI for my grandma

I created a SQLite database for my grandmother to store all her poems because I was tired to see her search/copy/paste across many different Word documents. Yet I have still to convince her to use it. ...
0
votes
0answers
40 views

Database columns dependent on another table column

For illustrate suppose I have two tables, let's say "Client" and "Cart": Client: ID; Primary; Autovalue Name; Debt; Cart: ID; Primary; Autovalue Client; value of Client->ID Product; Value; ...