Forum Replies Created
-
AuthorPosts
-
RiteshMember
Tunneling can be configured in two easy steps.
1) Upload SQLyogTunnel.php ( found in the MySQL installation folder ) to your web server using any FTP client.
2) Type the complete URL to SQLyogTunnel.php in the HTTP Tunneling URL input field.
This is still in BETA and the help file is not fully updated. The release version would have complete documentation on setting up HTTP/SSH Tunneling.
We are still not frozen the commercials and licensing policies.
RiteshMemberCurrently, SJA requires a PRIMARY KEY to sync table(s).
If you dont have a PRIMARY KEY then the best solution would be to just add an auto_incremenet column to the table.
RiteshMemberSQLyog supports table level comments. To specify COMMENTS for a table, click on Advanced Properties… button.
HTH
RiteshMemberCurrently, SQLyog dosnt support syncing of FK in Structure Sync Tool.
This featured is planned for one of the future releases of SQLyog.
RiteshMemberThis feature is planned for SQLyog Max.
RiteshMemberThis is a known bug and has already been fixed in SQLyog 4.0 😀 Would you like to be notified when the 4.0 BETA comes out?
RiteshMemberPlease upgrade to 3.71 as SQLyog 3.6x uses an old MySQL client library :huh:
RiteshMemberOne of the possible solutions that comes to my mind:
1) Start using MySQL instead of Access at the client-end.
2) Schedule a “Data Sync Job” using SQLyog. As required, SQLyog will only update the changed rows during the sync process. You can do away with exporting data to CSV, etc.
If you still need to use the “front-end” features of Access, use Access to make an ODBC connection to MySQL.
RiteshMemberCan you mail me the XML schema that you are using?
RiteshMemberYou can use SQLyog's Structure Sync Tool (Tools -> Structure Synchronization Tool) to generate the correct ALTER TABLE statements.
However, what you require is a schedulable Structure Sync Tool. Currently, you cannot schedule Structure Sync Tool. We may add it in one of the future versions of SQLyog.
RiteshMemberAs of SQLyog 3.71, we dont monitor size of bulk insert statements. You have to unselect BULK INSERT STATEMENT option, if the query is going beyond the limit.
This is a good feature request and I have added it up in our TO-DO list.
Thanks for your request.
RiteshMemberCurrently, SQLyog does not support importing of indexes and foreign keys in its ODBC Import Tool. You have to create them using SQLyog's Index Manager (Table -> Manage Indexes) and Relationship Manager (Table -> Manage Relationships) after importing the data.
Importing of Indexes and Relationships are planned for SQLyog 4.1
RiteshMemberPlease upgrade to SQLyog 3.71. This bug has been fixed in SQLyog versions starting from 3.7 🙂
RiteshMemberWhich version of SQLyog are your using?
RiteshMemberSelect the table in the ObjectBrowser.
Select Table -> Import Table Data From CVS… . Enter the filename and the correct escaping sequences and press Import. Thats it 🙂
-
AuthorPosts