Sql-server – HeidiSQL, attach/register database in MSSQL server

database-administrationsqlsql server

How to attach (or register) an existing MSSQL database to a server Using HeidiSQL

Best Answer

You can always do this with a query:

CREATE DATABASE [YourDB] ON ( FILENAME = N'd:\path\to\YourDB.mdf' ),( FILENAME = N'd:\path\to\YourDB_log.ldf' ) FOR ATTACH

EXEC sp_attach_db @dbname = N'YourDB', 
    @filename1 = 
N'd:\path\to\YourDB.mdf', 
    @filename2 = 
N'd:\path\to\YourDB_log.ldf';

Related Solutions

Sql-server – How to duplicate MSSQL database on the same or another server

backup the database
restore the database under a new name and/or on another server

Both these operations can be performed from Enterprise Manager (SQL2000) or its replacement SQL Management Studio (SQL2005+), or the TSQL commands BACKUP and RESTORE.

Note: you can restore a database backed up from SQL2000 on SQL2005 with not issues in most cases, but not the other way around.

Sql-server – MSSQL Database Replication to MySQL

You can probably use SQuirreL SQL client (in Java) to export tables and then import them into MySQL via JDBC . I doubt there is a ODBC method of doing what you need.

Also, you could export the SQL database to a CSV file and then import to MySQL using the command:

LOAD DATA LOCAL INFILE C:\test.csv
INTO TABLE tbl_temp_data 
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'

Best Answer

Related Solutions

Sql-server – How to duplicate MSSQL database on the same or another server

Sql-server – MSSQL Database Replication to MySQL

Related Topic