Posts Tagged ‘2008’

Re-attaching SQL Server 2008 databases with Filestreams in a different path

Wednesday, July 7th, 2010

I’ve recently been moving servers and when I moved the databases, I was unable to re-attach them with a different path for the filestream folder. ┬áThe following blog post has a solution –

The Rambling DBA: SQL 2008 Filestream and Attach Database.

SQL Management Studio 2008 Import/Export Data (Replacement for DTS)

Wednesday, July 1st, 2009

The old SQL Enterprise Manager used to have something called Data Transfer Services, which allowed you to transfer data between SQL Server and a different database using ODBC.  This was curiously lacking in SQL Server Management Studio 2005 (at least the Express one) unless I missed it.

However, in the 2008 version, you can right click on a database, select All Tasks and there are options for Import Data and Export Data, which open an appropriate wizard to guide you through the process.