Re: How to replicate or backup SQL 2000 and MySQL from a remote site?
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Tue, 18 Jul 2006 19:59:10 -0400
You need to export your data. That is the correct term.
It sounds like your current hosting company is holding you hostage. The
easiest way to accomplish what you are trying to do is to have them do a
backup and have you retrieve that backup. Should they be unwilling to do
that you might be able to bcp the files, use DTS to export them to the other
server, or to export them to web pages.
Note you can use DTS over post 1433 should they exposed this to you.
Its not a good situation to be in.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"xfile" <cou-cou@xxxxxxxxxxxxxxxxx> wrote in message
news:Oexca%23rqGHA.4932@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
Apology is mine, and my question was indeed for SQL 2000.
It's just that we are moving to SQL 2005 now, so we might need some
reference books for it.
And my question was not from MS SQL to MySQL - sorry again for the
misunderstanding.
We have one MS SQL (2000) database and one MySQL database with our current
hosting company.
But we are planning to move to another hosting who will give us a MS SQL
2005 and MySQL database. The reason for switching to another hosting
company is the original one can't even help us to configure proper
collation for MS SQL and thus won't support the additional languages from
our users.
We wish to "move" (PS: I don't even know what is the proper term to use)
the tables and data store from the old MS SQL database at the current
hosting company to the new MS SQL database at the new hosting company, and
do the same for the MySQL database from the old one to the new one.
The new hosting company told us they can do it but will charge $45/hr
which is kind of expensive for a small company like us.
So I was wondering if we could do it ourselves plus we have never done any
backup before - so if something goes wrong, we are totally screwed.
Thanks again and sorry for the confusions.
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:eJ$JO2gqGHA.4492@xxxxxxxxxxxxxxxxxxxxxxx
I'm sorry I thought your question was SQL 2000, your subject seems to
indicate it was. My apologies:)
SQL 2005 does not natively support replicating to MySQL.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"xfile" <cou-cou@xxxxxxxxxxxxxxxxx> wrote in message
news:%23EeULigqGHA.2464@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
Thanks for the kind information and offer for an sample chapter.
It'd be even better if you'd write a similar book for SQL 2005 and
MySQL.
Just a suggestion, and many thanks.
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OpcWV$eqGHA.4492@xxxxxxxxxxxxxxxxxxxxxxx
You can use replication for this. Review the notes in the sample
chapter in my sig for an example of this.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"xfile" <cou-cou@xxxxxxxxxxxxxxxxx> wrote in message
news:ehWOtH$pGHA.1600@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,
We don't know database very well and we are using both MS SQL 2000 and
MySQL from our hosting company.
So far, we are lucky for not experiencing any problems.
But we wish to know how could we "replicate" or "backup" the database
(if possible) and the data (including tables, if possible) from the
remote database.
We have access to Enterprise Manager, PhpAdmin, MySQL Administrator,
and SQL 2005's management tool.
Appreciate your advise or kindly point us to where could we find more
detailed instructions.
.
- Follow-Ups:
- References:
- Prev by Date: Re: How to replicate or backup SQL 2000 and MySQL from a remote site?
- Next by Date: Re: Managing transactional replication
- Previous by thread: Re: How to replicate or backup SQL 2000 and MySQL from a remote site?
- Next by thread: Re: How to replicate or backup SQL 2000 and MySQL from a remote site?
- Index(es):
Relevant Pages
|
