SQL Server 2008 to 2000 - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server 2008 to 2000

Author

Topic

sanjay5219
Posting Yak Master

240 Posts

Posted - 2014-08-18 : 06:12:40

HI All,

I have a situation here which I can not avoid is to restore the backup of SQL 2008 to SQL 2000. I know it is not possible but there should be some way

PLease suggest

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-08-18 : 08:00:54

1. Restore your databse to SQL 2008 or later
2. Generate scripts to build the database and tables
3. Generate scripts to insert the data. (see: http://blogs.msdn.com/b/martijnh/archive/2010/06/24/sql-server-2008-r2-generating-insert-statements-for-a-table.aspx)
4. Run scripts on SQL 2000.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-08-18 : 09:16:49

Or you can use the Copy Database Wizard on SQL Server 2008?

Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-23 : 02:17:05

export using SSIS \ DTS.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources