Re: [Koha] MYSQL to SQL Sever
You could set-up the MySQL server containing coha as a linked server in MS SQL Server. You could then perform queries against it from within the MS SQL Server environment, update it - strongly NOT advisable - and/or copy its contents to a local (MSSQLSRV) DB. On Sunday, December 7, 2014, Sina Stewart sina_sina1...@live.com wrote: Dear All i have a question about if possible to transfer the data stored in koha database to another SQL server or Oracle database in another machine up to date and automatically , to be like as working on SQL or oracle database , i have a problem in my work there are need a system running SQL or Oracle server and i don't want to change KOHA .. can any one advise me ... Thank's ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz javascript:; http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MYSQL to SQL Sever
Hi Sina. The only supported database for Koha is MySQL. On 7 December 2014 at 18:12, Sina Stewart sina_sina1...@live.com wrote: Dear All i have a question about if possible to transfer the data stored in koha database to another SQL server or Oracle database in another machine up to date and automatically , to be like as working on SQL or oracle database , i have a problem in my work there are need a system running SQL or Oracle server and i don't want to change KOHA .. can any one advise me ... Thank's ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MYSQL to SQL Sever
hi David Yes i know that the only supported database is MySQL , i asking about if i can transfer data to oracle or SQL server directly, like install a tool on koha server to do trnsfer to another machine .. Thank You Date: Mon, 8 Dec 2014 08:18:29 +1300 Subject: Re: [Koha] MYSQL to SQL Sever From: david.n...@gmail.com To: sina_sina1...@live.com CC: koha@lists.katipo.co.nz Hi Sina. The only supported database for Koha is MySQL. On 7 December 2014 at 18:12, Sina Stewart sina_sina1...@live.com wrote: Dear All i have a question about if possible to transfer the data stored in koha database to another SQL server or Oracle database in another machine up to date and automatically , to be like as working on SQL or oracle database , i have a problem in my work there are need a system running SQL or Oracle server and i don't want to change KOHA .. can any one advise me ... Thank's ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MYSQL to SQL Sever
Hi Sina, I don't understand what exactly you are trying to do. If you just want to transfer data from Koha's database to Oracle database, then these might be helpful: http://www.oracle.com/technetwork/database/migration/mysql-093223.html https://docs.oracle.com/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm#BABHGAHC Arslan On Mon, Dec 8, 2014 at 9:46 AM, Sina Stewart sina_sina1...@live.com wrote: hi David Yes i know that the only supported database is MySQL , i asking about if i can transfer data to oracle or SQL server directly, like install a tool on koha server to do trnsfer to another machine .. Thank You Date: Mon, 8 Dec 2014 08:18:29 +1300 Subject: Re: [Koha] MYSQL to SQL Sever From: david.n...@gmail.com To: sina_sina1...@live.com CC: koha@lists.katipo.co.nz Hi Sina. The only supported database for Koha is MySQL. On 7 December 2014 at 18:12, Sina Stewart sina_sina1...@live.com wrote: Dear All i have a question about if possible to transfer the data stored in koha database to another SQL server or Oracle database in another machine up to date and automatically , to be like as working on SQL or oracle database , i have a problem in my work there are need a system running SQL or Oracle server and i don't want to change KOHA .. can any one advise me ... Thank's ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk arslan.far...@szabist-isb.edu.pk +92 514 863 363-65 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MYSQL to SQL Sever
Short answer is no, long answer is yes possibly such a tool exists, but the schema would have to be changed. Perhaps if you told us what you planned to do with it once you moved it to a proprietary database server we could offer better suggestions. Chris On 8 December 2014 5:46:58 pm NZDT, Sina Stewart sina_sina1...@live.com wrote: hi David Yes i know that the only supported database is MySQL , i asking about if i can transfer data to oracle or SQL server directly, like install a tool on koha server to do trnsfer to another machine .. Thank You Date: Mon, 8 Dec 2014 08:18:29 +1300 Subject: Re: [Koha] MYSQL to SQL Sever From: david.n...@gmail.com To: sina_sina1...@live.com CC: koha@lists.katipo.co.nz Hi Sina. The only supported database for Koha is MySQL. On 7 December 2014 at 18:12, Sina Stewart sina_sina1...@live.com wrote: Dear All i have a question about if possible to transfer the data stored in koha database to another SQL server or Oracle database in another machine up to date and automatically , to be like as working on SQL or oracle database , i have a problem in my work there are need a system running SQL or Oracle server and i don't want to change KOHA .. can any one advise me ... Thank's ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- David Nind | david.n...@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MYSQL to SQL Sever
... and this may be relevant as well: http://ilbot2.kohaaloha.com/koha/2012-07-29#i_1007492 Arslan On Mon, Dec 8, 2014 at 10:04 AM, Arslan Farooq arslan...@gmail.com wrote: Hi Sina, I don't understand what exactly you are trying to do. If you just want to transfer data from Koha's database to Oracle database, then these might be helpful: http://www.oracle.com/technetwork/database/migration/mysql-093223.html https://docs.oracle.com/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm#BABHGAHC Arslan On Mon, Dec 8, 2014 at 9:46 AM, Sina Stewart sina_sina1...@live.com wrote: hi David Yes i know that the only supported database is MySQL , i asking about if i can transfer data to oracle or SQL server directly, like install a tool on koha server to do trnsfer to another machine .. Thank You Date: Mon, 8 Dec 2014 08:18:29 +1300 Subject: Re: [Koha] MYSQL to SQL Sever From: david.n...@gmail.com To: sina_sina1...@live.com CC: koha@lists.katipo.co.nz -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk arslan.far...@szabist-isb.edu.pk +92 514 863 363-65 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MYSQL to SQL Sever
Thank you at all all i want to transfer data daily like backup to Oracle database on another machine , i don't want to running koha on Oracle , but transfer data automaticlly to Oracle server to be as Oracle datadase , just read from oracle server Thank You Subject: Re: [Koha] MYSQL to SQL Sever From: chr...@catalyst.net.nz Date: Mon, 8 Dec 2014 18:10:09 +1300 To: sina_sina1...@live.com; koha@lists.katipo.co.nz Short answer is no, long answer is yes possibly such a tool exists, but the schema would have to be changed. Perhaps if you told us what you planned to do with it once you moved it to a proprietary database server we could offer better suggestions. Chris On 8 December 2014 5:46:58 pm NZDT, Sina Stewart sina_sina1...@live.com wrote: hi David Yes i know that the only supported database is MySQL , i asking about if i can transfer data to oracle or SQL server directly, like install a tool on koha server to do trnsfer to another machine .. Thank You Date: Mon, 8 Dec 2014 08:18:29 +1300 Subject: Re: [Koha] MYSQL to SQL Sever From: david.n...@gmail.com To: sina_sina1...@live.com CC: koha@lists.katipo.co.nz Hi Sina. The only supported database for Koha is MySQL. On 7 December 2014 at 18:12, Sina Stewart sina_sina1...@live.com wrote: Dear All i have a question about if possible to transfer the data stored in koha database to another SQL server or Oracle database in another machine up to date and automatically , to be like as working on SQL or oracle database , i have a problem in my work there are need a system running SQL or Oracle server and i don't want to change KOHA .. can any one advise me ... Thank's Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] MYSQL to SQL Sever
Sina Stewart schreef op ma 08-12-2014 om 06:46 [+0200]: Yes i know that the only supported database is MySQL , i asking about if i can transfer data to oracle or SQL server directly, like install a tool on koha server to do trnsfer to another machine .. You can transfer data there, though you'd have to find a conversion tool yourself, I don't know of any (I don't work with proprietary software in general.) There may be data changes/data loss in the process though as not all SQL servers handle things in the same way. I certainly would recommend NOT moving the data back under almost any circumstances. This would not be a backup, there are better ways (built in if you use the packages) to do backups. Also, there's virtually no chance that you'll be able to run koha off of it. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] MYSQL to SQL Sever
Dear All i have a question about if possible to transfer the data stored in koha database to another SQL server or Oracle database in another machine up to date and automatically , to be like as working on SQL or oracle database , i have a problem in my work there are need a system running SQL or Oracle server and i don't want to change KOHA .. can any one advise me ... Thank's ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha