vodo9090
15-08-2012, 02:16 AM
بسم الله الرحمن الرحيم
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
http://www14.0zz0.com/2012/08/14/23/857705056.gif
(2) Next
Click 'Next
http://www14.0zz0.com/2012/08/14/23/890017599.gif
(3) Select database and objects
Select the database that you want to convert, and check on 'Scripts all objects in the selected databases'
http://www14.0zz0.com/2012/08/14/23/975467848.gif
(4) Convert Options
Set options:
'Script for Server Version' = 'SQL Server 2005'
'Script Data' = 'True'
'Scirpt Database Create' = 'True'
http://www14.0zz0.com/2012/08/14/23/499885899.gif
(5) Output Option
Select option 'Script to file', 'Single file' and 'Unicode text'
http://www14.0zz0.com/2012/08/14/23/456132284.gif
(6) Finish'
View summary and click 'Finish'.
http://www14.0zz0.com/2012/08/14/23/521285651.gif
(7) Result
Now you got a complete database creation script with data. It can be executed on target database server.
http://www14.0zz0.com/2012/08/14/23/913139111.gif
(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
(9) Execute the Script
When finished, You should get converted database of SQL Server 200
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
http://www14.0zz0.com/2012/08/14/23/857705056.gif
(2) Next
Click 'Next
http://www14.0zz0.com/2012/08/14/23/890017599.gif
(3) Select database and objects
Select the database that you want to convert, and check on 'Scripts all objects in the selected databases'
http://www14.0zz0.com/2012/08/14/23/975467848.gif
(4) Convert Options
Set options:
'Script for Server Version' = 'SQL Server 2005'
'Script Data' = 'True'
'Scirpt Database Create' = 'True'
http://www14.0zz0.com/2012/08/14/23/499885899.gif
(5) Output Option
Select option 'Script to file', 'Single file' and 'Unicode text'
http://www14.0zz0.com/2012/08/14/23/456132284.gif
(6) Finish'
View summary and click 'Finish'.
http://www14.0zz0.com/2012/08/14/23/521285651.gif
(7) Result
Now you got a complete database creation script with data. It can be executed on target database server.
http://www14.0zz0.com/2012/08/14/23/913139111.gif
(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
(9) Execute the Script
When finished, You should get converted database of SQL Server 200