» Home » Databases » Page 1
Providing multi-version databases for backward compatibility for production applications/databases
Category : Programming Languages

How can I manage multiple versions of a database easily?


I have some data (as views as selects for data originating in tables from other schemas), which other database may reference using various means including database synonyms & links.


I wish to provide a sort of interface/guarantee in-case future for applications/databases which use this data. All of this is for


View Replies


Good online resource for common databases / open databases?
Category : Databases

I am trying to find the best area to download SQL tables of common subjects like states, countries, zip codes. Maybe even public/government information like FDA or FCC information.
Does such a resource exist and is it mature?


View Replies


Can a deadlock in a databases affect other databases or hung entire server?
Category : Databases

This sounds pretty strange, but there is ocurring in a databases of a bunch we've got in a server, we can tell by the output on the log, but this seems to be affecting another databases, since the systems hungs when the deadlock occur.


We've identified the objects involved in the deadlock event, but none lives in the databases from the system we are using.


I still need t


View Replies


I have root access to all my mysql databases. how can i export/import all the databases at once?
Category : Databases

I have root access to all my mysql databases. how can i export/import all the databases at once?


View Replies


In mysql, the show databases; command doesn't list all of my databases
Category : Databases

I can access all of my databases with HeidiSQL, but if I go to the mysql.exe window and use show databases; only 2 of them show up out of 11. These are all databases on 127.0.0.1. Any ideas on why?


View Replies


How to select databases based on users access to allowed databases?
Category : Programming Languages

I have a following command that executes when you log in as administrator with windows authentication right to SQL Server 2008 R2.


var sqlAdapter =
new SqlDataAdapter(@"select dtb.name as [Name],
CAST(case when dtb.name in ('master','model','msdb','tempdb') then 1
else dtb.is_distributo

View Replies


Are document-oriented databases meant to replace relational databases?
Category : Databases

Recently I've been working a little with MongoDB and I have to say I really like it. However it is a completely different type of database then I am used. I've noticed that it is most definitely better for certain types of data, however for heavily normalized databases it might not be the best choice.


It appears to me however that it can completely take the place of just about any


View Replies


Let MySQL users create databases, but allow access to only their own databases
Category : Databases

I want to have multiple a MySQL users to be able to issue commands like


CREATE DATABASE dbTest;

But I also want each of these users to be able to see and access only their own databases.


All I could find was how to either create the databases by a DBA and grant the privileges on this database to the specific user:


GRANT ALL PRIVILE

View Replies


Comparision of Relational databases and Graph databases
Category : Databases

Can someone explain to me the advantages and disadvantages for a relation database such as MySQL compared to a graph database such as Neo4j?


In SQL you have multiple tables with various ids linking them. Then you have to join to connect the tables. From the perspective of a newbie why would you design the database to require a join rather than having the connections explicit as edg


View Replies


How to prevent a user from being able to see other databases and the tables from other databases?
Category : Databases

I want to create a postgres user that can access only one database on the postgres server at all.


Currently my flow is:


create database database1;
create user user1 with password 'pass';
grant all privileges on database database1 to user1;


but user1 can still see a list of dbs, users, tables etc. Is there a way to prevent that user from seeing that


View Replies


Next
2012 / 2017 Copyrights BigHow , All Rights Reserved .