473,225 Members | 577 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,225 software developers and data experts.

Restore of Case Insensitive Database to a Case Sensitive Database - SQL Server 2000

Yesterday I received a response to my CI/CS Collation problem and the
recommendation was to try and restore a CI Collation database to a CS
Collation database. After creating a blank CS database a full restore
(Force restore over existing database) does change the Collation to
CI. I'm unsure as to how I can restore without changing the
Collation. Any suggestions?
Jul 20 '05 #1
2 6890
Hi. Check out this article:

http://www.sql-server-performance.co...parison_sp.asp

If appears that if you can put the CI db on another box and create a
linked server to it you should be able to bring over everything to the
CS db and avoid all your collation issues by setting one flag.

I've recently been wrestling with collation issues too due to
developing with SQL2K PersEd and then trying to migrate to SQL2K for
production. What a nightmare. In my case, I want to use the
production server's default collation and I saw an article about
restoring one collation over another (it sounds like that's what you
tried) but it didn't work for me either. I resorted to renaming the
old db and scripting all the objects in it, removing any DDL
references to collation settings (so that running the scripts would
use the new db's default), creating a new database with the original
db name, and then running the scripts to create the new objects. Then
via DTS I ran queries to bring all the data over. My databases are
fairly small and this was still a lot of work but it succeeded. It may
not be a viable option for you though.

Good luck, and if you find an easier way of doing this please let me
know.

JT

sw******@optimalinternet.com (Sue Swanson) wrote in message news:<c9*************************@posting.google.c om>...
Yesterday I received a response to my CI/CS Collation problem and the
recommendation was to try and restore a CI Collation database to a CS
Collation database. After creating a blank CS database a full restore
(Force restore over existing database) does change the Collation to
CI. I'm unsure as to how I can restore without changing the
Collation. Any suggestions?

Jul 20 '05 #2
Sue Swanson (sw******@optimalinternet.com) writes:
Yesterday I received a response to my CI/CS Collation problem and the
recommendation was to try and restore a CI Collation database to a CS
Collation database. After creating a blank CS database a full restore
(Force restore over existing database) does change the Collation to
CI. I'm unsure as to how I can restore without changing the
Collation. Any suggestions?


This does not seem like a workable way to me. It is possible
that the default for new tables in the new database would be CS, but
the existing tables in the backup would retain their CI collation.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

32
by: Elliot Temple | last post by:
Hi I have two questions. Could someone explain to me why Python is case sensitive? I find that annoying. Also, why aren't there multiline comments? Would adding them cause a problem of some...
5
by: Madjid Nasiri | last post by:
Hi, I am basic in oracle. My Old programs write with Delphi and Databases: Access, Paradox, MySQL, Microsoft SQL. I write my code (SQL code) case-insensitivae, but now i need use oracle database....
2
by: Captain Flack | last post by:
I have a SQL Server database hosted with a web hosting company. The SQL Server was clearly set up to be case sensitive, however, I want this particular database to be case-insensitive. I have...
2
by: Dean | last post by:
I have already install my Microsoft SQL server 2000 as not case sensitive, how to I change it to be case sensitive?
3
by: Jeff | last post by:
I have a SQL7 database that was installed as case-insensitive. /* Sort Order = 52, Case-insensitive dictionary sort order. */ This database contains a table that has a varchar column which...
3
by: Jon Jacobs | last post by:
I attempt to back up a database on one server and restore it on my local machine. This is what the query text looks like: restore database model from Disk='c:\JQJ\mydump\model.bak' with...
4
by: aki999 | last post by:
We need to install CI database on CS server, and there are some issues with stored procedures. Database works and have CI collation (Polish_CI_AS). Server has coresponding CS collation...
2
by: Tom | last post by:
Hi, Our development team is adding DB2 8.1 compatibility to our existing application which currently supports SQLServer 2000. Our code is written to take advantage of SQLServer's ability to ...
4
by: xAvailx | last post by:
Hello: I didn't find any documentation that notes save point names are case sensitive, but I guess they are... Stored Proc to reproduce: /* START CODE SNIPPET */ If Exists (Select * From...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.