Schema script export

[Valgardur]

Would it be possible to add an script export to the toolset? I sometimes need to compare the structure of two databases, but I cannot connect to both simultanously. So exporting the script to create all database objects would be very helpful... I can then use the script to generate the structure and run the comparison. I know there is a similar feature in Microsoft's SQL Management Studio, but I would like to use one tool... and the MS scripting could be improved...

[alexa]

You can compare backups or snapshots (can be stored on version control systems) by selecting relevant in the 'Type' dropdown menu on the 'Source and Target' page of the 'New Schema Comparison' wizard. Please refer to the 'How To: Select Source and Target Connections' and 'Version Control Connection' topics in the product's Help documentation for details.

[Valgardur]

Thanks, this may help in some situations. But in others I want to export a schema script to create a new database at a test site... being able to generate a script would be very helpful.

[alexa]

You can create a new empty schema, compare the existing one with the newly created, and generate the synchronization script.

Also, you could vote for the following suggestion on our UserVoice forum: http://devart.uservoice.com/forums/1770 ... ase-to-sql

[Valgardur]

Thanks, but my problem is, and the reason for my entry.. there is no Generate Schema Script when I right click

[Valgardur]

Thanks but I cannot compare to the existing one as I cannot connect to both databases at the same time.

Another useful thing is to create a backup copy of a schema...

So, it is still far too easy to use MS SQL Studio to generate the script. But this is a reason I need both dbForge and SQL Studio, and I would really like to simplify my tools environment.

So, please, can you add this to suggestions?

[alexa]

You could vote for the suggestion on our UserVoice forum above.