SQL help :D

02/27/2011 15:18 R0CK7Y#1
hey guys
i have finish my server but still a few things :D
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
02/27/2011 16:17 Alladrios#2
Here is the code you need to use to backup your database.
Make sure you have created a Backup_Shaiya_DB folder in D.

02/27/2011 17:16 R0CK7Y#3
i don't want to save the Database i just need to replace the tables only
02/27/2011 17:34 Alladrios#4
With this you can save the tables and then replace them, sigh.

You can this also for example to import a CSV:

02/27/2011 18:40 R0CK7Y#5
and how can i save it with CSV ?

Quote:

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

02/27/2011 18:42 Alladrios#6
Simply run a select from all columns and save as csv.
02/27/2011 19:08 R0CK7Y#7
ammm srry but can u give me more information about it ?

i didnt understand that
02/27/2011 19:33 Alladrios#8
[Only registered and activated users can see links. Click Here To Register...]

Uploaded with [Only registered and activated users can see links. Click Here To Register...]
02/27/2011 19:58 R0CK7Y#9
tyvm :D really u help me alot with that :D
02/27/2011 20:06 R0CK7Y#10
and again :S

Quote:

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)".
02/27/2011 20:08 Alladrios#11
Make sure to truncate the table before trying to import the csv.

[Only registered and activated users can see links. Click Here To Register...]