[Request] BlackRogue Database in sql 2005

01/06/2012 14:44 Dr.Abdelfattah#1
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

PHP Code:
CREATE DATABASE [StockTraderDBON 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 .LDFSIZE 6272KB MAXSIZE 2048GB FILEGROWTH 10%) 




9) Execute the Script


When finished, You should get converted database of SQL Server 2005
01/06/2012 14:52 PortalDark#2
thnx, ppl really needed this guide even if is a request, many ppl dont know how to do this
btw, forgot to add a final step

10) be kral
01/07/2012 02:47 Dr.Abdelfattah#3
-.- dump
Quote:
link posted and post deleted but not tested yet
[Only registered and activated users can see links. Click Here To Register...]
01/07/2012 06:09 EuSouHunteR#4
waiting this DB too..
01/07/2012 09:03 redcoco#5
Good job Bro <3
01/07/2012 15:38 Janick_#6
No idea if it works cus i could not choose to what version i wanted to script it to.. This is just the AccountDB, tell me if it works then i'll do it for the others also.
01/07/2012 15:52 Darkness™#7
account and shard db.

[Only registered and activated users can see links. Click Here To Register...]
01/07/2012 21:20 CrystalCoder#8
Quote:
Originally Posted by Darkness™ View Post
account and shard db.

[Only registered and activated users can see links. Click Here To Register...]
lol are you kidding or your serius its empty no data in REF
much more this DB are UseLess
01/07/2012 23:06 Dr.Abdelfattah#9
Quote:
Originally Posted by Janick_ View Post
No idea if it works cus i could not choose to what version i wanted to script it to.. This is just the AccountDB, tell me if it works then i'll do it for the others also.
Thank you for try to help :)
I will try it now , but u forgot to check to make script with data content ,

Quote:
Originally Posted by Darkness™ View Post
account and shard db.

[Only registered and activated users can see links. Click Here To Register...]
Thanks friend , but u forgot also to check (enable) to script the data content in the rows .
01/07/2012 23:09 X_RedDark_X#10
Realy Good Jop Dr <3
01/07/2012 23:21 Dr.Abdelfattah#11
add small part to make scripts with data content
--------------------
If you scroll down to Table/View Options, as shown, you will see all the script options. Among these options is Script Data. Set that to True and specify any of the other options you want for your script. When you are ready, click Next. [Only registered and activated users can see links. Click Here To Register...]
01/08/2012 16:28 KarstenBier#12
i have test it but there is no option with script data well DR. Abdelfattah i have send you a pm with Team viewer data´s well pm me back if you want check it or try to fix that than i upload it for all here

sry for the bad english
01/11/2012 05:25 Dr.Abdelfattah#13
Quote:
Originally Posted by KarstenBier View Post
i have test it but there is no option with script data well DR. Abdelfattah i have send you a pm with Team viewer data´s well pm me back if you want check it or try to fix that than i upload it for all here

sry for the bad english
to which email u send :) ?
and ty for try to help , wait u ..
+ DUMP for any other one !
01/14/2012 11:53 KarstenBier#14
i see a other posted the sql2005 files also well , well here is my link [Only registered and activated users can see links. Click Here To Register...]
01/14/2012 12:38 djoctan#15
why crash pets silk items no horses ?you cant help me? dc from server spawn pets