SQL help :D

[R0CK7Y]

hey guys
i have finish my server but still a few things
but all i need is how to Save your Tables in the Database and load it again

cuz i need to save skills table and load it in another Database

[Alladrios]

Here is the code you need to use to backup your database.
Make sure you have created a Backup_Shaiya_DB folder in D.

 Spoiler

USE OMG_GameWEB
GO
BACKUP DATABASE OMG_GameWEB
TO DISK = 'D:\Backup_Shaiya_DB\OMG_GameWEB.bak';
GO
 
USE PS_Billing
GO
BACKUP DATABASE PS_Billing
TO DISK = 'D:\Backup_Shaiya_DB\PS_Billing.bak';
GO
 
USE PS_ChatLog
GO
BACKUP DATABASE PS_ChatLog
TO DISK = 'D:\Backup_Shaiya_DB\PS_ChatLog.bak';
GO
 
USE PS_GMTool
GO
BACKUP DATABASE PS_GMTool
TO DISK = 'D:\Backup_Shaiya_DB\PS_GMTool.bak';
GO
 
USE PS_GameData
GO
BACKUP DATABASE PS_GameData
TO DISK = 'D:\Backup_Shaiya_DB\PS_GameData.bak';
GO
 
USE PS_GameDefs
GO
BACKUP DATABASE PS_GameDefs
TO DISK = 'D:\Backup_Shaiya_DB\PS_GameDefs.bak';
GO
 
USE PS_GameLog
GO
BACKUP DATABASE PS_GameLog
TO DISK = 'D:\Backup_Shaiya_DB\PS_GameLog.bak';
GO
 
USE PS_StatData
GO
BACKUP DATABASE PS_StatData
TO DISK = 'D:\Backup_Shaiya_DB\PS_StatData.bak';
GO
 
USE PS_Statics
GO
BACKUP DATABASE PS_Statics
TO DISK = 'D:\Backup_Shaiya_DB\PS_Statics.bak';
GO
 
USE PS_UserData
GO
BACKUP DATABASE PS_UserData
TO DISK = 'D:\Backup_Shaiya_DB\PS_UserData.bak';
GO

[R0CK7Y]

i don't want to save the Database i just need to replace the tables only

[Alladrios]

With this you can save the tables and then replace them, sigh.

You can this also for example to import a CSV:

 Spoiler

BULK
INSERT [PS_GameDefs].[dbo].[ProductList]
FROM 'c:\ProductList.import.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

[R0CK7Y]

and how can i save it with CSV ?

Msg 4860, Level 16, State 1, Line 1
Cannot bulk load. The file "c:\ProductList.import.csv" does not exist.

[Alladrios]

Simply run a select from all columns and save as csv.

[R0CK7Y]

ammm srry but can u give me more information about it ?

i didnt understand that

[Alladrios]

Uploaded with

[R0CK7Y]

tyvm really u help me alot with that

[R0CK7Y]

and again :S

Bulk load: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature.
Bulk load: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature.
Msg 4866, Level 16, State 1, Line 1
The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

[Alladrios]

Make sure to truncate the table before trying to import the csv.