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
0answers
55 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 ...
3
votes
1answer
266 views

Which program does *this instance* java.exe belong to? Why is it there, and can I remove it safely?

Since I'm stuck in deciding for sure if I should just delete C:\WINDOWS\system32\java.exe ... (I use the java.exe from C:\Program Files\Java[javaversion]\bin, which I explicitly set in my path ...
0
votes
0answers
153 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
3answers
97 views

I have a mysql table with 150k rows and do regular updates. Updates can take 1-3seconds. What options do i have to reduce this?

I have a table (mysql) that has 150k rows. During the day there are multiple updates (1000s) that change an int value to another int value (update table set field = ? where table.id = ?). nothing ...
10
votes
1answer
29k views

How to: Database Model in Visio 2013

I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
0
votes
0answers
22 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
0answers
14 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 ...
1
vote
1answer
137 views

Is there a way to change the query a report uses in Libreoffice Base or better yet to select the query at the time a report is run?

I have a standard set of data that I always want out of a report, however it could be based on a query of any of the values. Is it possible to set it up so I double click on a report and it would let ...
3
votes
3answers
236 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
15 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
22 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 ...
2
votes
1answer
2k views

Cleared vs. Unformatted partition in GParted

I am running a database-like application that writes and reads data directly to and from a raw block device. I would like to create a new partition for this purpose, and I am using GParted. I've ...
0
votes
2answers
75 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 ...
-1
votes
3answers
4k views

mysql access denied for 'root'@'name of the computer'

I am getting this error everytime im trying to connect to my database Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'root'@'name of the computer' ...
0
votes
1answer
100 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 ...
3
votes
2answers
2k 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
0answers
91 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 ...
0
votes
2answers
824 views

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

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 ...
3
votes
1answer
96 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
210 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 ...
14
votes
3answers
21k views

How to export mysql schema from phpmyadmin?

I have a huge db that hangs the server if I try to export it, is there a way I can export it without all the data? Only the tables structure.
0
votes
2answers
1k views

Can't detach database in SQL Server Management Studio after accidentally deleted mdf file

I'm working with a bunch of *.mdf files which I'm attaching on my local computer. After I accidentally deleted the a folder containing some of the *.mdf files, I'm unable to view the databases in SQL ...
0
votes
1answer
33 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
204 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
108 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
2k 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 ...
0
votes
1answer
211 views

In Mysql Workbench, where is Synchronize Model with Database

As displayed in Mysql Database Synchronization documentation. I cannot find this particular Synchronize Model with Database window / wizard under Database -> I have Mysql Workbench 6.0.9.11421 ...
-4
votes
2answers
2k 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
57 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 ...
0
votes
1answer
247 views

MS Access 2010 “The expression ”|“ you entered is invalid.”

This a very odd problem and I am hoping that someone here can figure it out. I get this error when working in a database and trying to FILTER a table by column and more than 1 value. For instance, ...
2
votes
2answers
273 views

Record bash_history to private database for all users?

I want to be able to setup a MySQL database and record all commands issued on my server by username and command. Is this possible, and if so, how would I set it up?
1
vote
2answers
122 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
441 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
30 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 ...
4
votes
1answer
2k views

How to display text in UTF8 from mysql /phpmyadmin?

I have a database with multiple tables. The database and table and every row of table is set to utf8_romanian_ci. Every name which I import that contains diacritics will not be displayed correctly. ...
1
vote
0answers
95 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
1answer
942 views

Wordpress Creating Empty database

WordPress is creating an empty database, there is a database but with out any values. I am on local WAMP Server 2.4 (PHP 5.4) Windows 8 Wordpress 3.6 (also tried 3.5.1) WAMP Apache is Giving some ...
1
vote
1answer
2k views

How do you create database diagrams in Visio 2013?

I'm not trying to reverse engineer a database, simply trying to create a database diagram from scratch in Visio 2013 (Standard edition). If I choose the "Crow's Foot Database Notation.vstx" template ...
0
votes
0answers
64 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; ...
0
votes
2answers
3k views

Configuring PHPMyAdmin to connect to remote database

After Googling the possibility of using PHPMyAdmin to connect to remote databases, I found this article, which confirms that this is supported after a simple config edit. In the article, the author ...
0
votes
0answers
81 views

How can data collation from different sources in Excel file be accomplished?

I am trying to make a main database Excel file from 5 different colleagues in the same company using Office 2013. The format is going to be same, but how to keep this automatically updated in the Main ...
0
votes
0answers
228 views

Difference between AWS RDS and AWS Opsworks MySql layer?

We are migrating everything over to opsworks and presently we have an RDS server setup for our database. Our plan for deployments is this: Have our production stack (Stack-A) Have our staging stack ...
0
votes
3answers
811 views

Looking for a central image database and tagging system for a group of users [closed]

I'm doing IT support for a small volunteer organisation who needs to centrally store and organize around 2500 photos. Can anyone here recommend a database or similar system which matches the following ...
0
votes
3answers
103 views

Are databases more expensive to host and serve than files? [closed]

I've observed a large percentage of hosts have very harsh limits on database space but generous limits on disk space. 100GB disk / 2 GB database seems quite common. To me, this makes little sense ...
0
votes
1answer
83 views

postgres, change data field type of a table

I am using postgres and I have a table with a column whose data type is timestamp without time zone. I would like to change the data type to bigint. I am trying to store number of seconds since 1970 ...
-1
votes
1answer
36 views

What type of database is used in large softwares? [closed]

I recently made an application in Java FX. The database used in it was MySQL. When I tried to run my application a system I got some errors because MySQL was not present in that system. My doubt is ...
1
vote
1answer
229 views

Stubborn “Read-only” notification in Excel won't go away

I have a table in Excel that includes a set of cells copy-pasted from a TFS bulk edit worksheet. I'm usually careful and paste values only so that I don't get any of the data validation, etc. I'd like ...
0
votes
1answer
103 views

Multiple requests shut down MySQL

I have some problems with my MySQL database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems: Every day at the ...
2
votes
2answers
7k views

How can I create an ERD for my phpmyadmin database?

Is there a way I can create an Entity Relationship Diagram for my PHPMyAdmin database?
0
votes
1answer
27 views

Editing finished mysql table

I'm new to mysql and I want to edit my table. My primary key should be auto generated. So where can I get the option to edit my table? thanks