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 |
|
fabianus76
Posting Yak Master
191 Posts |
 Posted - 2006-04-23 : 10:32:41
|
| Hello!I did a sql-dump form a db to copy it into a new db (db serves for DotNetNuke). The problem is that now, despite the fact that the same values should be copied the letters like "ä, ö, è, ë" are shown up in the new portal in a different manner – example: "ü" = "ü"Any idea what is wrong?Regards, Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-04-23 : 10:38:43
|
| How did you do the transfer?If it was a backup and restore then it will have retained the collation of the source database and the data will be ok. If you created the database and copied the data then the collations could be different and the data converted.If the dtaa is ok then it is probably a client profile that is the problem - missing code pages to convert the data for display.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-04-23 : 10:53:12
|
| Hallo nr!Thank you very much for your quick help!I did not do a backup but an export into t-sql and then I importet this as a script in the new db. I do not know what is "collation". This is certainly the source of the problem... could you help me to understand this notion and how I may correct the new db? In this case, if I understand well, the data that is executed by my t-sql script file is correctly registered in the db, but there is some defintion on how to interpret it that has to be corrected... right?Regards, Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-23 : 11:14:13
|
| Are you in a position to backup the database from the original server and restore to the new server? That would retain all aspects of the database structure, as well as the data itself.Kristen |
|
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-04-23 : 11:22:17
|
| Hi Kirsten, thank you for your help!I fact I could get the backup of the db. But for one I would like to be able to do it this way if it is not too difficult and for two I would like to pass from sql-server 2005 back to 2000... you think this is no problem with the back-up function?Regards, Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-04-23 : 14:02:29
|
| You can't restore a v2000 database onto v2000.You need to make sure that the destination database has the same collation as the source - if you do a backup/restore with different collations then the database will end up with a different collation from the server and probably cause problems.Check the collation on the source server (right click on the database in enterprise manager and select properties). Now install the destination with that collation and then you can backup/restore without problem.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-24 : 04:49:41
|
| "You can't restore a v2005 database onto v2000" - gotta warm those pinkies up on a Monday morning Nigel!"I would like to be able to do it this way if it is not too difficult"Its not that its "difficult", its just that it leads to a raft of other possible problems, and likely long-term maintenance issues.But if you are going from 2005 to 2000 then you ain't got much choice! But I reckon that will have a raft of problems all of its own, such that you'd be better to a) either stick with 2000 or b) move all of the servers to 2005.Kristen |
|
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2006-04-24 : 15:14:44
|
| Hello nr, Hello Kristen, thank you very much for your help!Regards, Fabianmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
|
|
|
|
|
|
"ü" becomes "ü" :-(