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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-19 : 08:31:59
|
| Katarina writes "Hi there, what is the easiest way to migrate data (databases) from case insensitive MS SQL 7 server to case sensitive MS SQL 7 server? I've just discovered that database backup and restore doesn't work between two servers with different case sensitivity.The two servers are not connected directly nor they're on the same LAN so data import/export is not the option. Is there any other way? Thanks. Katarina" |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-11-19 : 08:42:32
|
| You can probably use bcp or DTS.***************************************Death must absolutely come to enemies of the code! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-19 : 14:10:52
|
| You could also use the copy database wizard. I'm not a fan of using wizards because I don't think that one learns anything when using them, but this might be the easiest and fastest way for you to migrate the data. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-19 : 14:38:30
|
| If they're not connected via any type of network at all then your options are pretty limited. One method you might try is detaching the data file(s) and re-attaching on the other server. I don't know if this solves the problem as I can't remember whether case-sensitivity is server or database specific on SQL Server 7.0. Take a look in Books Online under "sp_detach_db" and "sp_attach_db" and its related links.If that does not work, then you'll have to use royv's suggestion of bcp. You'll have to export all the data to text files and then bcp them back into the new server. You'll also need to script out all of the database objects and run the script to create them on the new server first. |
|
|
|
|
|
|
database migration