[GUID] How To Convert SQL 2008 DB To SQL Server 2005

[Keyeight]

here is how to do i didnt make this tut by my self i copyed it cuz i see alot of guys ask about that i dont know if there another way or no i fund it and i used it befor

----------------------------------------------------------------------------
Requirements

If you are trying to restore database backup of SQL Server 2008 to SQL Server 2005, you are bound to fail. Database backup of SQL Server 2008 is not compatible backward, you cannot restore it to SQL Server 2005. The following is a solution to convert databases of SQL Server 2008 to 2005

----------------------------------------------------------------------------
Step by Step Guide
1) Start convert wizard

Open SQL Server Management Studio2008. in 'Object Explorer', right click the database that you want to convert. Select 'Tasks' > 'Generate Scripts...'.


2) Next

Click 'Next'.



3) Select database and objects

Select the database that you want to convert, and check on 'Scripts all objects in the selected databases'



4) Convert Options

Set options:

'Script for Server Version' = 'SQL Server 2005'
'Script Data' = 'True'
'Scirpt Database Create' = 'True'

5) Output Option

Select option 'Script to file', 'Single file' and 'Unicode text'.



6) 'Finish'

View summary and click 'Finish'.



7) Result
Now you got a complete database creation script with data. It can be executed on target database server.



8) Amend Script
Open the generated script in SQL Server Management Studio 2005. Find the following section and amend the path to proper data folder

    CREATE DATABASE [StockTraderDB] ON  PRIMARY 
( NAME = N'StockTraderDB', 
FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB.mdf ,
 SIZE = 4352KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'StockTraderDB_log', 
FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB_log.LDF',
 SIZE = 6272KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

9) Execute the Script

When finished, You should get converted database of SQL Server 2005
Related Resources
Restore a SQL Server 2008 Database into SQL Server 2005

[PortalDark]

you did a good work
but for some reason, I cant stop to think this was posted by abdel already
i could be wrong

[AceSpace]

Originally Posted by mats0o0o0

here is how to do i didnt make this tut by my self i copyed it cuz i see alot of guys ask about that i dont know if there another way or no i fund it and i used it befor

----------------------------------------------------------------------------
Requirements

If you are trying to restore database backup of SQL Server 2008 to SQL Server 2005, you are bound to fail. Database backup of SQL Server 2008 is not compatible backward, you cannot restore it to SQL Server 2005. The following is a solution to convert databases of SQL Server 2008 to 2005

----------------------------------------------------------------------------
Step by Step Guide
1) Start convert wizard

Open SQL Server Management Studio2008. in 'Object Explorer', right click the database that you want to convert. Select 'Tasks' > 'Generate Scripts...'.


2) Next

Click 'Next'.



3) Select database and objects

Select the database that you want to convert, and check on 'Scripts all objects in the selected databases'



4) Convert Options

Set options:

'Script for Server Version' = 'SQL Server 2005'
'Script Data' = 'True'
'Scirpt Database Create' = 'True'

5) Output Option

Select option 'Script to file', 'Single file' and 'Unicode text'.



6) 'Finish'

View summary and click 'Finish'.



7) Result
Now you got a complete database creation script with data. It can be executed on target database server.



8) Amend Script
Open the generated script in SQL Server Management Studio 2005. Find the following section and amend the path to proper data folder

    CREATE DATABASE [StockTraderDB] ON  PRIMARY 
( NAME = N'StockTraderDB', 
FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB.mdf ,
 SIZE = 4352KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'StockTraderDB_log', 
FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB_log.LDF',
 SIZE = 6272KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

9) Execute the Script

When finished, You should get converted database of SQL Server 2005
Related Resources
Restore a SQL Server 2008 Database into SQL Server 2005

Its already by Dr.AbdelFattah He only copied again
Try to fix your english!
~Stop copy other things.

[zChopper]

He said it was copied, get off his ***** .

[ThElitEyeS]

i don't think they even read it

[Dare_]

pff .. stop flame guyz im already saw alot of theards.. ask for how to convert sql 2008 db to sql 2005 thanks mastoo ..

[zChopper]

Exactly my point proven, btw your signature is PURE taken from a different server ( Paradise ) , who's going to come to your server if your lacking originality?

[Dare_]

Originally Posted by zChopper

Exactly my point proven, btw your signature is PURE taken from a different server ( Paradise ) , who's going to come to your server if your lacking originality?

its not ur buss ?

[PortalDark]

Originally Posted by zChopper

Exactly my point proven, btw your signature is PURE taken from a different server ( Paradise ) , who's going to come to your server if your lacking originality?

can you make me a favor?
try to quote or at least say to whom you are talking, because i got lost on one of you post since i didnt knew if you where talking to me or someone else

[zChopper]

Originally Posted by PortalDark

can you make me a favor?
try to quote or at least say to whom you are talking, because i got lost on one of you post since i didnt knew if you where talking to me or someone else

Yeah sorry , will do next time !

[Keyeight]

will i didnt know that`s there was another thread posted about it before sorry about it i got this tut from another site not about sro at all and i think all who know me also know that`s i have bad english and i say yes so stop act like a teacher rok dont be kid

thx for useful post`s

[BestOnWorld]

Good Work
Thanks

[Keyeight]

you are welcome guys i hope someone can till another way im sure there are another way to convert DB from 2008 to 2005