Q:What to use for importing data to MS SQL Server: sqlcmd or isqlw?


SQL Server Recovery Kit automatically detects the server version the database was used on. Therefore, if the database was used on MS SQL Server 2000, the program writes the isqlw tool to the saved scripts for importing into the new database. If the database was used on MS SQL Server 2005 or higher, the sqlcmd tool is used in the scripts. If you want to import data to a database on a server with a version different from the original one, you should use the tool for the corresponding server:

  • Isqlw - for MS SQL Server 2000
  • Sqlcmd - for MS SQL Server 2005 and higher