Re: How to import mysql data into SQL Server 2000 ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 19:15:39 +0530

Hi,

That is actually a dump file of MYSQL. You cant use that in SQL Server
directly. Ways to transfer data from MYSQL to SQL server is given below:-

1. DTS

2. Generated comma seperated text file in MYSQL and use BCP IN / to load it.

Better and easiest option is to use DTS to copy data between

Thanks
Hari
MCDBA

<.> wrote in message news:OWZ8OZ5QEHA.2404@TK2MSFTNGP09.phx.gbl...
> Hi all,
>
> I have a *.sql backup file, is there any method to import the backup into
> SQL Server 2000 ? I cannot open it in the SQL Query Analyzer.
>
> Thanks a lot !
>
>

Relevant Pages

  • Re: SQL server vs mySQL ???
    ... SQL Server has the broadest range of tools and support utilities of any database system on the planet--by far. ... MS SQL versus MySQL? ... As of 5.0, MySQL finally supports stored procedures, so they are very similar there (you can genericize your data access a bit due to sprocs in both). ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Transfer LARGE DB from MySQL to SQL Server 2K5 problems
    ... newsgroups are managed (and making that a selling point for MSDN ... forums, which, needless to say, drives me away from the MS web sites, and is ... I am going through the MySQL ODBC v3.51 driver, ... streaming across the wire to my SQL Server box. ...
    (microsoft.public.sqlserver.dts)
  • Re: Newbie, True and False
    ... All commands, Insert, Update etc work fine with MySql, but not with MsSql. ... First time working on an SQL database. ... will need to relearn when using sql server. ...
    (microsoft.public.sqlserver.clients)
  • Re: Access 2007 and MySQL
    ... Anyone tried MySQL as backend for recent Acc2k7 FE developments? ... You can however if you want choose SQL server for your back end and then you ... For the most part most your recordset code and most queries should work as ... Set rstRecords = CurrentDb.OpenRecordset ...
    (comp.databases.ms-access)
  • Synchronising a DataRow in one DataSet with a structurally identical DataRow from another DataSet
    ... Supposing you had several remote MySQL databases, one for each client, each ... SQL Server table on a nightly basis, ... DataSet from the destination SQL Server table which matches the primary key. ... existing record in the SQL Server table, so we instantiate a DataRow object ...
    (microsoft.public.dotnet.framework.adonet)