SQL Power Software Forum

Hi,

have you tried right clicking on the connection lines of the join?

Thanks,
Benjamin

Hi,

what exactly do you mean with a role playing dimension? Do you mean a time dimension?

You can create a new dimension and set TimeDimension as type. Add a hierarchy and you can add time related levels (year, quarter, month,...)

Benjamin

Hi,

sorry the previous post was most likely spam.

We currently don't have full support for DB2 (http://www.sqlpower.ca/page/sysreq) but you can file this issue in the bug tracking system at http://bugs.sqlpower.ca/bugzilla/

Thanks,
Benjamin

Hi,

the current version of SQL Power*Architect doesn't support views.

Thanks,
Benjamin

Hi,

which version of SQL Power Architect (SPA) are you using? You are saying you could connect to the same SQL Server 2008 before using SPA?

Benjamin

Hi,

now I know what you mean. i have the same issue sometimes. The best way to move a large table around is to zoom out first so that your table easily fits into the playpen, and then move the table.

Benjamin

Hi,

I currently don't have a SQL Server 2008 available to verify this issue. There are 2 versions of the JDBC driver available from Microsoft, you might want to try both:

Microsoft SQL Server JDBC Driver 2.0: http://goo.gl/8RPf
Microsoft SQL Server JDBC Driver 3.0: http://goo.gl/dZWG

Both drivers support SQL Server 2008. Let me know if you have any luck.

Benjamin

Hi,

I'm not sure if I understand your issue. Can you describe the problem in more detail?
In general you can use the zoom function to zoom out if a table is too big. This way you can still move it on the playpen.

Benjamin

Hi,

have a look at our FAQs, it explains how to create a new database type and how to install JDBC drivers: http://www.sqlpower.ca/page/faq-install

Benjamin

Hi,

can you confirm that the database user "test" has the permissions on SQL server to view all tables etc.? Maybe you can also try to connect with the db admin user.

Benjamin

Hi,

I'm sorry to hear about your decision. After reading that you had issues reverse engineering after you setup a UUID type I just tested it myself but I could not reproduce your issues.

Thank you for trying product,

Benjamin

Hi,

thanks for reporting this issue and taking the time to analyze it. I could reproduce some of the issues and entered it into our issue tracking system: http://bugs.sqlpower.ca/bugzilla/show_bug.cgi?id=3061

Thanks,
Benjamin

Hi Ricardo ,

thanks for your answer. I did some testing and I could confirm the issue.

I forwarded the issue to our developers: http://bugs.sqlpower.ca/bugzilla/show_bug.cgi?id=3058

Benjamin

Hi,

in the enterprise edition you could just add the data type INTERVAL yourself but for using the community edition I don't know of any better solution.

Thanks,
Benjamin

Hi,

just to clarify:
- The database you want to connect to on a SQL Server 2005? I'm asking because there is also a native Dynamics NAV database (also called "Classic").

- You can test the connection in Wabit (in the DB connection manager) and it is working?

Thanks,
Benjamin