|
What is the difference between database drivers and database dialects?
Answer Snippets (Read the full thread at stackoverflow):
A dialect is a variant on a query language....
A driver is a piece of software for accessing a database.
Original question:
what is the difference between database drivers and database dialects?
The question is ambiguous; here is my take.
|
|
How do you create a database backup of a mysql database in VB.Net?
Answer Snippets (Read the full thread at stackoverflow):
Mysql....
Mysqldump --host=[HOSTNAME] --user=[USER] --password=[PASSWORD] -R [DATABASE NAME] > [PATH TO BACKUP the mysql command instead.
I would write a stored proc, since MySQL 5.
Can read each table's data and write it to a new database.
|
|
I've bought a CSV United States business database with ~20 million records, which is divided to 51 databases, every database represents a state.
I need to write an ASP.NET MVC Web Application that will query this database, by state and more arguments....
Started by Alon on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Create a relationship between ....
But, do it in a structured'.
Create a single database, where you put all those records in.
As long as the table is correctly indexed it will offer better performance when things up .
Into one big database.
|
Ask your Facebook Friends
|
When do you test against an In-Memory Database vs. a Development Database?
Also, as a related side question, when you do use a Development Database, do you use an Individual Development Database, an Integration Development Database, or both?
Also++, for...
Started by Troy DeMonbreun on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
A real database is better suite of JUnit tests are those that do not have....
For my team, it's in-memory on developper machine, and the real-database on the continuous for your given test cases and a very particular operation is being tested.
|
|
Are there any guidelines on writing database tests so that you can refactor database "without fear" while doing evolutionary database design?
What aspects of database should be put to test while developing it? Any example would be great..
Started by StackUnderflow on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Over the time I have more and better tests and even bigger database changes go rather seamlessly....
Always fear every change you make to a database many times doing database changes.
And refactor the code so it passes the new tests .
|
|
Why should I use document based database like CouchDB instead of using relational database. Are there any typical kinds of applications or domains where the document based database is more suitable than the relational database?
Started by Bartosz Blimke on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
A good example is a database where you actually store to get your job done, a document oriented database....
CouchDB (from their website )
A document database server, accessible via a RESTful JSON API to describe your data as a set of columns.
|
|
I need to drop all the tables in a database without knowing their names beforehand. The typical procedure is to drop and then recreate the database but this is not an option. What is the best way to to it?
Started by Angel Chiang on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
You should use the information_schema tables to fetch the metadata about the database.
|
|
Anyone seen this before?
CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file C:\Documents and Settings\..\App_Data\HelloWorld.mdf failed. A database with the same name exists, or specified file ...
Started by Mark Cidade on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You either need to change the credentials used for the service, or move the database to another.
In to Management Studio connect to the database, and disconnect the long database name that looks like a file the error.
|
|
I've never got this working the first time, but now I can't seem to do i at all.
There is a connection pool somewhere using the database, so trying to drop the database when an application is using the database should give this error. The problem is there...
Started by Tommy on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
Db2 force applications....
Just as a tip if Arun's tip does not work, because an remote app is instantly reconnecting to the db .
This way is better than quiesce command which is asynchronous by nature .
I just use 'db2stop force', then 'db2start' , then drop db .
|
|
What do I have to consider in database design for a new application which should be able to support the most common relational database systems (SQL Server, MySQL, Oracle, PostgreSQL ...)?
Is it even worth the effort? What are the pitfalls?
Started by splattne on
, 18 posts
by 17 people.
Answer Snippets (Read the full thread at stackoverflow):
What you need....
These are the wrong answers and only lead to pain interpretations .
They will often say only talk to the database via stored procs to abstract out any sql.
Is to not use database specific sql and just code to ansi standards.
|
