April 23, 2008 at 11:38 pm
Good Morning Everyone...
Due to some problems i have to change my database from MS Sql Server Express Edition 2005 to Ms Sql Server 2000? Can anyone help me to solve my problem? One more thing is that the tables in express edition contains primary keys, foreign keys, views....
In one table there are attachments too...
regards
jeevan
April 24, 2008 at 12:12 am
You'll have to script the database structure, bcp the data out and then recreate the DB on SQL 2000 and import the data. There's no downgrade option for SQL.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 24, 2008 at 12:42 am
Thank you... but i am sorry to ask you to explain the steps in detail....
April 24, 2008 at 12:46 am
In management studio, right click the database Tasks ->Generate scripts
Script everything out. Then run that script on your sQL 2000 server. Taht will create the shell of the DB. All the tables, procs, views, etc, but no data.
Back on the SQL 2005 machine, use bcp (look in books online for the syntax of bcp. It's a command line tool) and export the data from each table to a file. Copy those files to the SQL 2000 machine, then use either bcp or Bulk insert to import them
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2008 at 11:01 pm
[font="Courier New"]
jeevanr (4/23/2008)
Good Morning Everyone...Due to some problems i have to change my database from MS Sql Server Express Edition 2005 to Ms Sql Server 2000? Can anyone help me to solve my problem? One more thing is that the tables in express edition contains primary keys, foreign keys, views....
In one table there are attachments too...
regards
jeevan
Jeevan,
You can refer the link below, this will help you!!!
Moving SQL2005 db to SQL2000 db[/font]
Regards..Vidhya Sagar
SQL-Articles
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply