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 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 > ___ 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
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 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 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
... 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 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 > 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
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 : > 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 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 -- Jesse Weaver ___ 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 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 >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
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 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 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
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 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. The only supported database for Koha is MySQL. On 7 December 2014 at 18:12, Sina Stewart 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
[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