Would anyone be so kind and point me in the rigth direction?
I have a MYSQL server and a MSSQL 2000 server.
MYSQL
Database name is Membership
Table is Users
Column is email_address.
I want to transfer the email_address data over to a column in an
existing MSSQL Database.
When I run the DTS wizard I can successfully connect to the MYSQL
database server, but the only option I get is to use a SQL Statement.
So this is what I have started with...
mysql_select_db('membership');
SELECT * FROM users WHERE email_address='"*"
If i try and preview I get an unexpected errror and if i run through
the wizard I get wrong systax at line 1.
I am a total novice at this and am stumbling around in the dark...
DBConvert for Access & MSSQL 2.0.0 ... DBConvert for Access & MSSQL is a database migration tool for data ... If a direct access to your MSSQL server is denied (insufficient ...privileges) you can save your data into a MSSQL Dump file to overcome ... (comp.software.shareware.announce)
Access2MSSQL PRO 1.2.0 ... Access2MSSQL Pro is a database migration tool for data conversion from ... MS Access database to MS SQL Server and from MSSQL to ...privileges) you can save your data into a MSSQL Dump file to overcome ... (comp.software.shareware.announce)
Re: Using a HEX differential when moving data files. ... You can create a full backup of your old database (which is an online ... new server and restore there, and make the new server live. ... > Is it possible to migrate a MSSQL server from one machine to another using ... > Any suggestions on a command line differential utility that will extract ... (microsoft.public.sqlserver.server)
Re: transfering mysql data ... > The mysql server on my machine is running under windows and is being ... The most normal use of mysqldump is probably for making a backup of ... See section 4.4.1 Database Backups.... (linux.redhat)
Re: copying an MS SQL database ... If you stop MSSQL Server's services, you're also bringing off line all other databases that reside on the server. ... If however there's not a specific reason, and you're simply trying to make a backup, why don't you use MS SQL's built-in backup capabilities to backup the database?... You can do so without having to bring SQL Server offline, and you can then backup the resulting "database.bak" file to tape, DVD, offiste, or wherever you wish. ... (alt.comp.lang.borland-delphi)
