+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, New SQL Server in Technical; We have a Capita UNIT-e database server (Further education MIS system), currently on Windows 2003 with SQL 2005. Now I've ...
  1. #1

    Join Date
    Jan 2007
    Posts
    948
    Thank Post
    8
    Thanked 34 Times in 26 Posts
    Rep Power
    21

    New SQL Server

    We have a Capita UNIT-e database server (Further education MIS system), currently on Windows 2003 with SQL 2005.

    Now I've built a new Windows 2008 R2 server with SQL 2012 - Both supported by Capita so no problems there.

    However, our in house developers link in to the SQL server with their custom reports and the like.

    If the new server has the same name as the old one (Obviously not at the same time!!), the same database instances, the same SA user password, would any links just work as if nothing had changed?

    Also, is there any benefit in then upgrading the MIS database to SQL 2012 schema? (Maybe I need to ask Capita on that one...)

    Thanks

  2. #2

    Join Date
    Apr 2006
    Posts
    382
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    44
    I don't know about Capita, so this is in general terms only: it's *probably* OK to do so, as the connections will probably just care about the server name, instance name and user.

    The sa password shouldn't matter, unless you're using the sa account for the applications/links - but that is very bad form indeed (on a par with logging in as the domain admin to read your email).

    The other thing to watch out for with SQL Server is that Microsoft deprecate features between releases - a project I work on had to be updated for SQL 2008 after some 2000-only features disappeared, for example. You're usually OK if the devs are doing basic SQL, but it's wise to check . . . .

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Depending on how they've implemented things, especially considering some workarounds for working with SIMS, you might have IPs thrown into .ini files rather than server names, so it could cause a problem if the ip is not the same. Otherwise, so long as dns is up to date i'd say it's okay.

    Be careful of stricter security settings on win 2008 though, because, the SQL ports won't be open. I'm pretty sure the SQL installation will warn you, not sure how it works with 2012.

    I think you'd have to upgrade the database to be 2012 compatible. Usually there is a migration routine. I don't think you can just drop your old db backup onto the new SQL setup.

    I'd be tempted to make a test server in a sandbox VM or on a private ip range and then bring in the custom scripts for testing, as well as seeing if things work in general.

SHARE:
+ Post New Thread

Similar Threads

  1. New SIMS Server - Windows 2008 R2 & SQL 2008 R2
    By MYK-IT in forum MIS Systems
    Replies: 23
    Last Post: 17th June 2010, 09:31 AM
  2. New SQL Server Check
    By Duke in forum Hardware
    Replies: 19
    Last Post: 23rd March 2010, 01:57 PM
  3. Replies: 3
    Last Post: 7th July 2006, 02:21 PM
  4. SQL Server
    By wesleyw in forum Windows
    Replies: 5
    Last Post: 28th June 2006, 08:42 AM
  5. sql server
    By chrbb in forum Windows
    Replies: 17
    Last Post: 18th January 2006, 11:23 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •