Exporting ALL Tables?

Questions and answers regarding general SQL and backend databases

Exporting ALL Tables?

Postby Kahuna » Mon Jan 12, 2009 9:02 pm

Hi Folks - I've realised that my export of a solution with data has only exported the tables that have a current form associated. This has left my development solution with a number of tables missing in comparison to the original!

I'm exporting from my development environment with MSSQL and importing to another development environment with MySQL.

I know there are a couple of data converters available from MSSQL to MySQL but unfortunately I don't have an environment where they are both (servers) installed currently (a text based converter that I've come across needs VB6 runtime and some other attributes that I don't have installed either).

I would imagine that I'd need to have a form related to every table in the solution to have it referenced in the repository, but is there another way to ensure these other tables in the database get exported from my dev solution?
(Servoy Version: 6.0.7 Win XP / 7 - SQL Server 2008 R2)
Ian Cordingley (Kahuna)
Kahuna
 
Posts: 1235
Joined: Thu Oct 26, 2006 1:39 am
Location: 1/2 NE UK 1/2 Olvera Spain

Re: Exporting ALL Tables?

Postby ngervasi » Mon Jan 12, 2009 10:49 pm

Well, out of my head I think that creating a bunch of bogus forms is the quicker way, a good practice would be to name them like "DEV_formname" just to be sure that you'll remember why they are there in a few months :)
Nicola Gervasi
sintpro.com
SAN Partner
ngervasi
 
Posts: 1485
Joined: Tue Dec 21, 2004 12:47 pm
Location: Arezzo, Italy

Re: Exporting ALL Tables?

Postby Kahuna » Mon Jan 12, 2009 11:02 pm

ngervasi wrote:Well, out of my head I think that creating a bunch of bogus forms is the quicker way, a good practice would be to name them like "DEV_formname" just to be sure that you'll remember why they are there in a few months :)


Thanks Nicola - thats really where I'm at too - at least I know I've not missed a point now!

Cheers
(Servoy Version: 6.0.7 Win XP / 7 - SQL Server 2008 R2)
Ian Cordingley (Kahuna)
Kahuna
 
Posts: 1235
Joined: Thu Oct 26, 2006 1:39 am
Location: 1/2 NE UK 1/2 Olvera Spain

Re: Exporting ALL Tables?

Postby lvostinar » Tue Jan 13, 2009 3:57 pm

Actually it exports any referenced table (form, relation, valuelist, calculation, aggregation). I don't think there is another way to export everything.
Laurian Vostinar
Servoy
lvostinar
 
Posts: 1062
Joined: Tue Feb 19, 2008 10:53 am

Re: Exporting ALL Tables?

Postby studiomiazzo » Wed Jan 09, 2013 6:56 pm

Thanks...you saved my life...
As a side note, maybe these kind of things should be made a little more clear, especially when exporting a solution.
User avatar
studiomiazzo
 
Posts: 124
Joined: Thu Jun 16, 2011 10:48 am
Location: Novara (IT)

Re: Exporting ALL Tables?

Postby lwjwillemsen » Wed Jan 09, 2013 9:26 pm

We use dummy relations to export all the tables.

Room for improvement within the Servoy solution export imho...
Lambert Willemsen
Vision Development BV
lwjwillemsen
 
Posts: 680
Joined: Sat Mar 14, 2009 5:39 pm
Location: The Netherlands

Re: Exporting ALL Tables?

Postby mboegem » Thu Jan 10, 2013 10:37 am

lwjwillemsen wrote:Room for improvement within the Servoy solution export imho...


As you can see below there's already a checkbox to export every table from a single referenced server. (this has been around for a while...)
So in case you have 4 databases with just any number of tables in it, you only need to reference a random table of each database and tick this checkbox.

The attachment svy_export.png is no longer available
Attachments
svy_export.png
svy_export.png (58.63 KiB) Viewed 5199 times
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1743
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Exporting ALL Tables?

Postby lwjwillemsen » Thu Jan 10, 2013 2:18 pm

Thanks Marc !

Lesson for me : First watch / look up and then speak...

Regards,
Lambert Willemsen
Vision Development BV
lwjwillemsen
 
Posts: 680
Joined: Sat Mar 14, 2009 5:39 pm
Location: The Netherlands


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 11 guests

cron