Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 00:03

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Request] BlackRogue Database in sql 2005

Discussion on [Request] BlackRogue Database in sql 2005 within the SRO Private Server forum part of the Silkroad Online category.

Closed Thread
 
Old   #1
 
Dr.Abdelfattah's Avatar
 
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,373
[Request] BlackRogue Database in sql 2005

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...'.


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

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
Dr.Abdelfattah is offline  
Thanks
10 Users
Old 01/06/2012, 14:52   #2
Chat Killer In Duty


 
PortalDark's Avatar
 
elite*gold: 5
Join Date: May 2008
Posts: 16,310
Received Thanks: 6,470
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
PortalDark is offline  
Thanks
3 Users
Old 01/07/2012, 02:47   #3
 
Dr.Abdelfattah's Avatar
 
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,373
-.- dump
Quote:
link posted and post deleted but not tested yet
Dr.Abdelfattah is offline  
Old 01/07/2012, 06:09   #4
 
elite*gold: 0
Join Date: Feb 2008
Posts: 158
Received Thanks: 15
waiting this DB too..
EuSouHunteR is offline  
Old 01/07/2012, 09:03   #5
 
redcoco's Avatar
 
elite*gold: 20
Join Date: Jan 2011
Posts: 735
Received Thanks: 764
Good job Bro <3
redcoco is offline  
Old 01/07/2012, 15:38   #6
 
elite*gold: 0
Join Date: Jul 2009
Posts: 986
Received Thanks: 193
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.
Attached Files
File Type: rar script.rar (22.7 KB, 35 views)
Janick_ is offline  
Old 01/07/2012, 15:52   #7
 
Darkness™'s Avatar
 
elite*gold: 0
Join Date: Jun 2009
Posts: 2,085
Received Thanks: 1,669
account and shard db.

Darkness™ is offline  
Old 01/07/2012, 21:20   #8
 
CrystalCoder's Avatar
 
elite*gold: 0
Join Date: Mar 2008
Posts: 1,106
Received Thanks: 226
Quote:
Originally Posted by Darkness™ View Post
account and shard db.

lol are you kidding or your serius its empty no data in REF
much more this DB are UseLess
CrystalCoder is offline  
Old 01/07/2012, 23:06   #9
 
Dr.Abdelfattah's Avatar
 
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,373
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.

Thanks friend , but u forgot also to check (enable) to script the data content in the rows .
Dr.Abdelfattah is offline  
Thanks
1 User
Old 01/07/2012, 23:09   #10
 
X_RedDark_X's Avatar
 
elite*gold: 0
Join Date: Jan 2012
Posts: 71
Received Thanks: 41
Realy Good Jop Dr <3
X_RedDark_X is offline  
Thanks
1 User
Old 01/07/2012, 23:21   #11
 
Dr.Abdelfattah's Avatar
 
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,373
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.
Dr.Abdelfattah is offline  
Old 01/08/2012, 16:28   #12
 
elite*gold: 0
Join Date: Jul 2007
Posts: 34
Received Thanks: 10
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
KarstenBier is offline  
Old 01/11/2012, 05:25   #13
 
Dr.Abdelfattah's Avatar
 
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,373
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 !
Dr.Abdelfattah is offline  
Old 01/14/2012, 11:53   #14
 
elite*gold: 0
Join Date: Jul 2007
Posts: 34
Received Thanks: 10
i see a other posted the sql2005 files also well , well here is my link
KarstenBier is offline  
Old 01/14/2012, 12:38   #15
 
elite*gold: 0
Join Date: Mar 2009
Posts: 210
Received Thanks: 14
why crash pets silk items no horses ?you cant help me? dc from server spawn pets
djoctan is offline  
Closed Thread


Similar Threads Similar Threads
[Release] Database 120 Cap and Skill + Jupiter Map - Running SQL Server 2005
01/04/2013 - SRO PServer Guides & Releases - 62 Replies
Database Added Map Jupiter work D12 weapons and items Level Users and Skills 120 Max item mall Work 100% All Region Work Magic Pop rates 100x Fix honor ranking
Fixed DataBase vSRO Files Cap120+Skil On SQL Server 2005
07/02/2012 - SRO PServer Guides & Releases - 45 Replies
CLOSED
Black Rouge Server Database(SQL 2005)
03/20/2012 - SRO Private Server - 9 Replies
Hello guys some people have been wanting black rouge files backup-ed with sql 2005 so here it is.. i dont have sql 2005 thats why its a query. This .rar doesnt contain the original account db.. download here Multiupload.com - upload your files to multiple file hosting sites! Virustotal scan http://www.virustotal.com/file-scan/report.html?id =8c80601de2120278ae03f7ef60077edbbe4cce8b755e8498b fb413bd4ee54a9c-1325177048# MD5 : 6a6086dc35d1623334dc9e1e5ff2da9f
[REQUEST] Some Database
02/16/2010 - Dekaron Private Server - 11 Replies
Hi, i kinda need something from some one, if its not to much to ask for well i need a full database (account, cash, billing, character) but i needs to have accounts in then, it may be from a dead server that had a small amount of chars and accounts example 50 accounts and 100 characters becuz the database backups i have including the ones on dkunderground dont have allot of accounts matching the characters
[Request]Database
07/03/2009 - CO2 Private Server - 12 Replies
Ok.. I have my old source... DreamCO.. and it works and all.. but my BACKUP Database has somethin wrong with it... How can I create a database to that source?



All times are GMT +2. The time now is 00:03.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.