[jira] [Commented] (CAY-1921) Migrate Dabase Schema - SqlServer 2008

["Andrus Adamchik (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAY-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13957961#comment-13957961 ] 

Andrus Adamchik commented on CAY-1921:
--------------------------------------

Unfortunately it is a bit more complex than using schema from a DataMap. Essentially in Cayenne there's no requirement that a DataMap should only contain objects from a single schema (or same catalog for that matter, but catalog can be controlled by the DB connection URL). I think a reasonable solution might be a schema selector dialog (or a schema selection dropdown in the migrations dialog), similar to how reverse-engineering is done. This would allow user to select a desired schema for a given operation. 

> Migrate Dabase Schema - SqlServer 2008
> --------------------------------------
>
>                 Key: CAY-1921
>                 URL: https://issues.apache.org/jira/browse/CAY-1921
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Modeler
>    Affects Versions: 3.2M1
>         Environment: Windows 7
>            Reporter: Arkadiusz Milewski
>         Attachments: patch.txt, screenshot-1.jpg
>
>
> When using Migrate Database Schema with MsSqlServer 2008, jdbc driver
> <dependency>
> 	<groupId>net.sourceforge.jtds</groupId>
> 	<artifactId>jtds</artifactId>
> 	<version>1.3.0</version>
> </dependency>
> It shows not only tables from schema configured in cayenne but also system tables. For example tables like: columns, sysprotects and so on.



--
This message was sent by Atlassian JIRA
(v6.2#6252)