philduba.com

SQL Server 2005 Restore from SQL Server 2000 BAK File

Posted On August 21, 2007 8:58 AM By Phil in SQL Server

I had a problem that was racking my brain for quite some time. A project I was working on was an addition to a legacy system. I was given the code base and a backup file of the database. The file was generated from a SQL Server 2000 database. I am running SQL Server 2005 Developer on my local environment. I had the hardest time importing it using the Restore option in Management Studio. I kept getting that the the import could not be done. After wading through a ton of partial posts and cross references that no longer existed, I found this posting on the MSDN forum. It gave both SQL and Management Studio options. The worts part, all I had to do was click "Overwrite Database" in the Options of the Restore wizard, and I would have had this working a while ago. Well, now I have a reference in case I run into the same problem again.

Comments (3) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 3363 Views

Import/Export in SQL Server Management Studio Express

Posted On October 25, 2006 11:25 AM By Phil in SQL Server,General

After some Google searching, I found out why the Import/Export feature was not available for a database's Task menu in the new management studio: It just doesn't exist natively in the GUI. I had to upgrade to SP1 for the studio express edition, which can be found here. Once the upgrade is complete, navigate to C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe. This is the import wizard we all know and love. Nice to see Microsoft give out a tool to help us get accustomed to SQL Server 2005 and not give us a tool within the GUI to migrate data.

Comments (2) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 6252 Views