Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tabarto
Starting Member
1 Post |
 Posted - 2008-01-22 : 02:56:23
|
| Hi guys,I’m not an expert of SQl server,I use MS SQL Server Management Studio Express to manage an Sql Server 2005. I’ve a Mdf file that I want export into backwards-compatible format that it’s possible to put inside a SQL Server 2000. How can I export my file into a compatible version for Sql Server 2000? What’s tool I need to do it? Thanks, have a nice day |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-22 : 05:02:05
|
| Hi tabartoBackup of 2005 doesn't restore on SQL 2000. Although,you can generate SQL Script from objtecs and run into SQL Server 2000 Database.Do as follows:1. Create new database in SQL 20002. Genarete script from objtects on the SQL 20053. Execute this script on the SQL 2000If you have data, use bcp utilities to export and import.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-01-22 : 11:26:36
|
| You can also use the Export Data task in SQL Server Management Studio (2005) to move the database. This is going to create a SSIS package that will move your data from 2005 to 2000.Chris Shawwww.SQLonCall.com |
|
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-01-22 : 11:29:12
|
| As I think about this a little more you may not have access to SSIS in SQL Server 2005 because of the edition that you are running. You would either use a full version of SQL Server 2005 with SSIS installed on it or start looking at BCP, as Jack replied.Chris Shawwww.SQLonCall.com |
|
|
|
|
|
|
From Sql 2005 to Sql 2000