DbVis Software
Home
Solutions
Forums
Users Guide
Release Notes
Download
Welcome
Login
Sign up
How can we help you today?
Enter your search term here...
Search
Login
or
Signup
to submit a new ticket
Check ticket status
Start a new topic
Discussions
DbVisualizer Forums
Support
Query Builder - database names dropped from the generated sql
a
anonymous
started a topic
over 16 years ago
[This topic is migrated from our old forums. The original author name has been removed
]
Hiya
I am creating joins between tables in two databases - so connecting databaseA.dbo.table1 to databaseB.dbo.table2
Everything works except that when the sql is generated it does not contain the database name when listing the FROM statements.
eg it will just say
FROM dbo.table1, dbo.table2
I then have to add the database names in manually.
Is this the expected funtionality?
Many thanks!
Jon Cheyne
2 Comments
Oldest First
Popular
Newest First
Sorted by
Newest First
a
anonymous
said
over 16 years ago
[This reply is migrated from our old forums. The original author name has been removed
]
Re: Query Builder - database names dropped from the generated sql
Ms SQL Server, client running on Ubuntu ...
Hans Bergsten
said
over 16 years ago
[This reply is migrated from our old forums.
]
Re: Query Builder - database names dropped from the generated sql
Hi Jon, We'll have a look at this. Which database are you using? Best regards, Hans
Comments to this discussion are now closed!
More topics in
Support
Forward Engineering
DB2 Database Connection Dropping every 20-30mins or so ?
roles are not unfolded
Install4j: Java(Tm) VM could not be started
Worksheet name default when exporting to Excel?
sqlformatter and extract
Bug with empty password
dbvis 5.0 gives error after opening
Saving file makes it incompatible with other SQL tools!!!?!?!?!?
Error Schema Name in References view.
See all 1316 topics
anonymous
I am creating joins between tables in two databases - so connecting databaseA.dbo.table1 to databaseB.dbo.table2
Everything works except that when the sql is generated it does not contain the database name when listing the FROM statements.
eg it will just say
FROM dbo.table1, dbo.table2
I then have to add the database names in manually.
Is this the expected funtionality?
Many thanks!
Jon Cheyne