|
Replies:
10
-
Pages:
1
-
Last Post:
Feb 20, 2011 7:47 AM
by: dbyy
|
Threads:
[
Previous
|
Next
]
|
|
|
|
|
|
Sql Export suggestions
Posted:
Feb 6, 2010 5:31 AM
|
|
|
Hi,
Is there a way to export a whole database in one file ? I couldn't find such an export, but it would be very usefull. To do an Import with over 200 tables seperatet in 200 files would be a pain.
What I found really cool is the function "Generate SQL" to clipboard, file ...
If this would work with database and included data it would be an very easy way to do a quick backup.
Greets
Xzen
|
|
|
|
|
|
|
Re: Sql Export suggestions
Posted:
Feb 6, 2010 9:21 AM
in response to: xzentorxz
|
|
|
Hi Xzen,
I asked the same question couple of years ago. May be it's already done. Let's find out from the Toad team - I hope this is done???
Gracias
Ernest Bonat, Ph.D.
|
|
|
Posts:
68
Registered:
8/22/07
|
|
|
|
RE: Sql Export suggestions
Posted:
Feb 8, 2010 9:56 AM
in response to: xzentorxz
|
|
|
XZen,
You can export your entire database into a script using the Export Wizard:
1) Tools | Export | Export Wizard...
2) Select Objects page:
a) Click the Databases radio button
b) Check both the Tables and the Views check boxes
c) Check the databases that you want to export in the Right Hand Side list
d) Press Next button
3) On the Select Output Format page
a) Change Output Format from "Comma Separated Variable" to "SQL Script"
b) On the RHS "Script Options" panel, select "Include DDL"
4) Continue through the wizard.
5) (Optional) If you only want the DDL, on the last page of the wizard "Save Settings and Template" there is an "Export Data" check box. Uncheck it.
Viola! You have a DDL script of your database
Dwight
|
|
|
Posts:
68
Registered:
8/22/07
|
|
|
|
Re: Sql Export suggestions
Posted:
Feb 8, 2010 10:13 AM
in response to: xzentorxz
|
|
|
XZen,
You can export your entire database into a script using the Export
Wizard:
1) Tools | Export | Export Wizard...
2) "Select Objects" page:
a) Click the "Databases" radio button
b) Check both the Tables and the Views check boxes
c) Check the databases that you want to export in the Right Hand
Side list
d) Press Next button
3) On the "Select Output Format" page
a) Change Output Format from "Comma Separated Variable" to "SQL
Script"
b) On the RHS "Script Options" panel, select "Include DDL"
4) Continue through the wizard.
5) (Optional) If you only want the DDL, on the last page of the wizard
"Save Settings and Template" there is an "Export Data" check box.
a) Check the "Save Template" check box.
b) Fill in a path for the template file, or use the "..." button
to navigate to a directory to save it.
c) Uncheck the "Export Data" check box.
6) Click the Finish button.
Viola! You have a DDL script of your database
Dwight
|
|
|
Posts:
68
Registered:
8/22/07
|
|
|
|
Re: Sql Export suggestions
Posted:
Feb 8, 2010 11:43 AM
in response to: xzentorxz
|
|
|
|
|
|
|
|
|
|
Re: Sql Export suggestions
Posted:
Feb 9, 2010 4:45 AM
in response to: Dwight
|
|
|
Hi Dwight,
That is almost the way I wanted it, but I still miss the function like "Creation Script & Data". And it would be nice if I could do the same with databases and toad would select all tables internal.
You think it will get implemented one day ?
greets
Xzen
|
|
|
|
|
|
|
Re: Sql Export suggestions
Posted:
Feb 9, 2010 4:51 AM
in response to: Dwight
|
|
|
Thats the point: either i can have one file and only the structure or i can have many files and a whole export, but i need one file and the structure and data.
|
|
|
|
|
|
|
Re: Sql Export suggestions
Posted:
Feb 9, 2010 8:32 AM
in response to: xzentorxz
|
|
|
Hi All,
I did ask for the same upgrade couple of years ago. I think need to have two possible options. Structure and data by table and structure and data by the entire database. I believe MySQL database programmers will use structure and data by the database the most today. Same question every year: When will this be done? I hope this year!
Many thanks to Toad for MySQL Development Team for keeping alive this excellent database development tool for the Open Source community!
Thanks much,
Ernest Bonat, Ph.D.
President | Visual WWW, Inc.
Cell:503.730.4556 | Fax:503.715.4888
ebonat@evisualwww.com | www.evisualwww.com
Visual WWW is an Open Source Application
Development and Training Shop
|
|
|
|
|
|
|
Re: Sql Export suggestions
Posted:
Mar 11, 2010 8:52 AM
in response to: xzentorxz
|
|
|
Hi Xzen,
We have been asking for this feature for many years and it has been never implemented. We hope to have that this year. We'll see.
Thanks
Ernest Bonat, Ph.D.
President | Visual WWW, Inc.
Cell:503.730.4556 | Fax:503.715.4888
ebonat@evisualwww.com | www.evisualwww.com
Visual WWW is an Open Source Application
Development and Training Shop
|
|
|
Posts:
1
Registered:
10/27/10
|
|
|
|
Re: Sql Export suggestions
Posted:
Oct 27, 2010 11:20 AM
in response to: xzentorxz
|
|
|
I don't know why so few people are asking for those "Scripts" enhancement features. I comes from the Microsoft SQL sides, with Toad, I can't select any objects(views, procedures ) then generate DDL and rerun it in Production system. The stored procedures script generated from Toad can't even run in Production unless "Delimiter" is added.
Lawrence
|
|
|
Posts:
12
Registered:
2/20/11
|
|
|
|
Re: Sql Export suggestions
Posted:
Feb 20, 2011 7:47 AM
in response to: Lawrence
|
|
|
hi folks,
Just a note to this thread.
It would be nice if the export wizard instead of creating many single files would store the whole backup into one file.
Reason: with a backup of e.g. 100 tables in database it is very cumbersome to create a restore for those tables.
e.g. phpmadmin creates such a file (including DDL for drop tables (if exists) and create the tables structure (and even can zip it up).
However I'm aware that with a high amount of data stored in db, the file can be very large (editing is almost impossible than).
It may help the in this context the "select ... Into Outfile"/"Load data Infile" ..options.
I also experienced some problems with backup file in text fields in the table contains "TABs" ort other 'special' characters.
Just MHO.
What do you think?
PS. can the backup 'template' be changed by a user (e.g. add conditionals DDL into the backup file) ?
Otherwise... It is a cool tool.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
