Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snakoil
Starting Member
24 Posts |
 Posted - 2001-05-28 : 10:08:00
|
| I'm having some trouble with simple DTS. I'va got some databases in SQLServer2000 and my server is on sqlserver7.0. I usualy restore the db on my computer and than transfer the data to the Server with a simple DTS(copy objects). Unfortunatly, I'm having trouble with varchars. The collation seem to be mistaken in the transfer. When I send French Character, it end up as Arabian Characters. (ex: ç ends up being €) I think it's the collation of the db on my computer...I know i can use a cursor to change the data in each rows but that's too dumb to be used. Is there a way that in the transfer, the collation could be kept?Mathieu DuhamelSQLServer DBA |
|
|
|
|
|
Transfer problem from 2000 to 7.0