|
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
|
I'm going to write a multi site content management system in ASP.NET. What will be faster: a database for every site, or one database for all sites?
Thanks.
EDIT: If a database for every site, which database should I use? XML?
Answer Snippets (Read the full thread at stackoverflow):
Also, that means your database tables will have to be more complex, making subscribers probably have same functions....
Hi,
A single database for all sites may end up being a bad choise in case you have websites with a large number of visits.
|
|
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.
|
|
Hello all, I need to create project in which there are two databases local and remote. Remote database needs to be synchronized daily with local database reflecting changes made in local database. I am using JAVA. Database is ORACLE. I have JAVA/JPA code...
Started by Xinus on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
During the synchronization, the remote database....
This is typically done by keeping a timestamp for each row .
I would not do this in Java, but look for native Oracle database synchronization mechanisms/tools happened in the central database.
|
|
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 am using MySql 5.1 Database.
I have created a Project database. (Temnplate Database)
and want to Create a copy of the same database from the Application, every time, User Creates A new Project.
How can I copy and Create a New Database of same structure...
Started by Ashok Gupta on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The -d flag.
To create a new copy, do a "create database new-database-name -ppass -d olddb | mysql -u user -ppass -Dnewdb
The new database must exist already.
Dump the database with the -d option.
|
|
Simple problem. I have an SQL Server database (MyData.mdf) and I want to convert it to a Compact database. (MyData.sdf) Just can't find the proper tool which can do this for me.
And I would also be able to convert the compact database back to a regular...
Started by Workshop Alex on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You might consider using SQL Server Integration Services (SSIS) to help manage... .
Have you tried any hidden options from SQL Server Studio?
They aren't directly convertible from one to the other; many aspects of SQL Server aren't supported in SQL Compact .
|
