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
Hi Sina. The only supported database for Koha is MySQL. On 7 December 2014 at 18:12, Sina Stewart <sina_sina1984@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.nind@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
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.nind@gmail.com To: sina_sina1984@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_sina1984@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.nind@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
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.ht... Arslan On Mon, Dec 8, 2014 at 9:46 AM, Sina Stewart <sina_sina1984@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.nind@gmail.com To: sina_sina1984@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_sina1984@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.nind@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.farooq@szabist-isb.edu.pk +92 514 863 363-65
... 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 <arslanone@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.ht...
Arslan
On Mon, Dec 8, 2014 at 9:46 AM, Sina Stewart <sina_sina1984@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.nind@gmail.com To: sina_sina1984@live.com CC: koha@lists.katipo.co.nz
-- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk arslan.farooq@szabist-isb.edu.pk +92 514 863 363-65
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_sina1984@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.nind@gmail.com To: sina_sina1984@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_sina1984@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.nind@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.
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: chrisc@catalyst.net.nz Date: Mon, 8 Dec 2014 18:10:09 +1300 To: sina_sina1984@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_sina1984@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.nind@gmail.com To: sina_sina1984@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_sina1984@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.
Just to verify, you're asking if there's a way to make a read-only copy of Koha's MySQL database in Oracle or SQL Server, so others can access the data there instead of in MySQL? Koha will still store and update its data in MySQL. 2014-12-07 21:46 GMT-07:00 Sina Stewart <sina_sina1984@live.com>:
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.nind@gmail.com To: sina_sina1984@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_sina1984@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.nind@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
-- Jesse Weaver
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
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_sina1984@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
participants (7)
-
Arslan Farooq -
Chris Cormack -
David Nind -
Jesse -
Manos PETRIDIS -
Robin Sheat -
Sina Stewart