Hello,
SomeOne can upload for me black rogue DB in sql 2005 ?
I need to make a fast guide how to setup those files , but i don't use sql server 2008 , so hope someone upload for us black rogue db in sql 2005
If u don't know how to convert the db from 2008 to 2005 just Follow this small 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...'.
[Only registered and activated users can see links. Click Here To Register...]
2) Next
Click 'Next'.
[Only registered and activated users can see links. Click Here To Register...]
3) Select database and objects
Select the database that you want to convert, and check on 'Scripts all objects in the selected databases'
[Only registered and activated users can see links. Click Here To Register...]
4) Convert Options
Set options:
'Script for Server Version' = 'SQL Server 2005' 'Script Data' = 'True' 'Scirpt Database Create' = 'True' [Only registered and activated users can see links. Click Here To Register...]
5) Output Option
Select option 'Script to file', 'Single file' and 'Unicode text'.
[Only registered and activated users can see links. Click Here To Register...]
6) 'Finish'
View summary and click 'Finish'.
[Only registered and activated users can see links. Click Here To Register...]
7) Result
Now you got a complete database creation script with data. It can be executed on target database server.
[Only registered and activated users can see links. Click Here To Register...]
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 2005
SomeOne can upload for me black rogue DB in sql 2005 ?
I need to make a fast guide how to setup those files , but i don't use sql server 2008 , so hope someone upload for us black rogue db in sql 2005
If u don't know how to convert the db from 2008 to 2005 just Follow this small 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...'.
[Only registered and activated users can see links. Click Here To Register...]
2) Next
Click 'Next'.
[Only registered and activated users can see links. Click Here To Register...]
3) Select database and objects
Select the database that you want to convert, and check on 'Scripts all objects in the selected databases'
[Only registered and activated users can see links. Click Here To Register...]
4) Convert Options
Set options:
'Script for Server Version' = 'SQL Server 2005' 'Script Data' = 'True' 'Scirpt Database Create' = 'True' [Only registered and activated users can see links. Click Here To Register...]
5) Output Option
Select option 'Script to file', 'Single file' and 'Unicode text'.
[Only registered and activated users can see links. Click Here To Register...]
6) 'Finish'
View summary and click 'Finish'.
[Only registered and activated users can see links. Click Here To Register...]
7) Result
Now you got a complete database creation script with data. It can be executed on target database server.
[Only registered and activated users can see links. Click Here To Register...]
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
PHP Code:
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 FilesMicrosoft SQL ServerMSSQL10.SQLEXPRESSMSSQLDATAStockTraderDB_log .LDF, SIZE = 6272KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
9) Execute the Script
When finished, You should get converted database of SQL Server 2005