|
Basically this task is pretty easy when you think about it... but i found no Answers in Microsoft Access or MSDN. I have to create a connection to an new Database and query the old one. After validating the old data, everything is written in a new fine...
Started by bastianneu on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Why you....
You can use a tool like database workbench .
If you can access the firebird database via ODBC, i suggest the mysql migration toolkit.
If no binary data in your database, I'd suggest just doing a csv export and reimporting.
|
|
After looking at a lot of questions..i found no real answer for this.
I redisigned an Database for our customer. With Microsoft Access i found a good Tool to get old table Data in my new well formed Database Structure. It is really easy but takes a lot...
Started by bastianneu on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
For migrating Firebird 1.5 to Firebird 2.1 : you just have to make a backup of your database with Firebird 1.5 server and restore your database with Firebird 2.1 server....
Or Database Workbench which are the best tools for Firebird.
|
|
Few months ago I have asked a question regarding how to change database location at runtime - I didnt get any solution for this problem yet.
I am needing to create more than 32,000 databases in mysql. The default data location of mysql data folder, after...
Started by MySQL DBA on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You could run more than....
I don't understand why 32000 - is mysql refusing to create more databases than that? What error do you get? Seems arbitrary - maybe this is a config variable that can be changed?
A few possibilities.
That sounds difficult.
|
Ask your Facebook Friends
|
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; use ....
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.
|
|
How do you create a database backup of a mysql database in VB.Net?
Answer Snippets (Read the full thread at stackoverflow):
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 used the Database Publishing Wizard to generate a script of the schema for a database, how do I make a new database based on this .sql file?
Started by Ryan on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
It depends, though, on what.
Run the sql file against the database, from the command line client or some other client:
sqlcmd -d on the server; new query in Management Studio) and just run the script.
|
|
I want to add the new tables to dbml file dynamically from another database
Thank you
Started by kirankumar on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If this is a SQL Server database, and the second database is on the same server, I'd suggest creating ....
A DataContext is intended to encapsulate a single database - or part of a single database.
You won't be able to do this.
|
|
I wrote some sql scripts to create a database and store data. I just noticed that the new tables and data are going to the master database.
I found that I can address the correct database if I scope out the database as so:
CREATE TABLE Practice1.dbo.Experiments...
Started by MedicineMan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Example:
Syntax
USE {database}
http://doc.ddart....
Also, you can state the database to use at the top of your script.
You have a drop down list on your toolbar that allows you to select what database you want the script to execute on.
|
|
Hello, I am trying to create a copy of a SQL Server 2008 database under a new name on the same server.
I have physical access to the machine. I have tried to create a full backup and then restore that backup under a new name and I get an error from SSMS...
Answer Snippets (Read the full thread at serverfault):
I got.
Or you can use T-SQL:
RESTORE DATABASE YourDatabase FROM DISK = 'C:\YourDatabase.bak' WITH REPLACE
Doh! The name of the database that you intend the copy to be must not exist.
Name altogether.
|
|
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 ....
Always fear every change you make to a database many times doing database changes.
And refactor the code so it passes the new tests .
|
