Search the Community
Showing results for tags 'database'.
-
Hi, I have been trying to figure out how to create a Batch file to automatically detach, delete and reattach a fresh sql2012 database. We use the databases for training and after each use we re-attach the fresh database. it is a tedious process as this needs to be done almost every day. I decided to try and automate this process, so far i have been able to detach, delete and attach a new database successfully but it drops the usernames and passwords and i do not understand why. "C:\Program Files\Microsoft SQL Server\MSSQL11.SIMS2012\MSSQL\Binn\Dbattach.exe" /SERVER=".\sims2012" /DATABASE="Engwe0" /USER="SA" /PASSWORD="Password1" /AUTODETACHMODE /AUTO pause call "C:\Program Files\Microsoft SQL Server\MSSQL11.SIMS2012\MSSQL\DATA\delete.bat" pause "C:\Program Files\Microsoft SQL Server\MSSQL11.SIMS2012\MSSQL\Binn\Dbattach.exe" /SERVER=".\sims2012" /USER="SA" /Password="Password1" /DATABASE="ENGwe0" /SOURCEDB="D:\Keystone\november15traindata_sims7.166_engwe_sql/ENGwe0.mdf" /AUTOATTACHMODE /AUTO pause this is the first time i have attempted a script and also the first time I've posted here, i would greatly appreciate any thoughts you may have Thanks In Advance!
-
Just building a new 2012 server with SQL 2012 for our new sims database this September (we are re-opening the school under a new DFE). I've been looking at the disk benchmarks and comparing old server with DELL MD3000i SAN to our new server which has RAID 10 (4 x 146GB 15k SAS with hot spare) These are the results: On the left is the old SQL server with SAN and right is New SQL server, the new SQL server is 10x faster on smaller file and 26x faster on larger files for read but the write speed lags by 3x behind until 64kb where it gets up to 3x faster at 8Mb files No question that reading our new sims database will be blisteringly fast in comparison to the old one but I'm concerned about the write speed at smaller files. Does anyone know what sort of data sizes SIMS writes back at? Will this decrease at smaller files have much of a performance impact when taking registers?
-
At St Paul's Girls' School we are seeking an enthusiastic and motivated Web & Database Developer to implement, develop and support the school's Portal/intranet based on Firefly (HTML/CSS/XML/XSLT), Management Information System (MS SQL) and Website (WordPress). This is an excellent opportunity to join one of the top schools in the country and make a real impact on the use of IT throughout the school. As well as a salary in the range of £28-33k, we can also offer professional training such as ITIL Foundation and various Microsoft Certifications. More information and an application form can be found on our website - Web and Database Developer | St Paul's Girls' School To apply please send all completed forms, your CV and a brief cover letter to [email protected].
-
New here, so didn't know where to post. My mother recently bought a country club, and we have been slowly adding amenities to the place. Now that the membership is growing, we want to go digital. We are wanting the membership idea to kind of be like a gym. We want scannable membership cards that will pull up a membership profile. I'm usually the tech savvy one of the group, but this project has just got me confused. I cannot find what I want. We need to find a database software that can link up to membership cards. Or maybe even just print out individual SKU barcodes to stick on the back of membership cards that we can scan. It doesn't have to be the magnetic strip. What's the best way to do this? We are so confused. Like I said, I'm normally pretty tech savvy, so I don't need a dumbed down answer. I just need to know what to download and buy, the rest i can figure out. Thank you so much to anyone who has ideas for us. -
I have installed a brand new Server 2008 R2 machine and installed SQL 2008 on it ready for migrating our SIMS install to SQL 2008 this summer. Following Microsoft's Best Practice Guide Separate database and transaction log files on different drives for optimal performance and disaster recovery I have three separate RAID volumes on this server. RAID 1 for system / C drive, RAID 5 for Data and RAID 5 for Logs I have set up SQL 2008 to use the separate drives for Data and Logs as default for new databases and confirmed that these settings are correct in the Server Database properties page through SQL Server Management Studio. However, when running the SIMSInst.exe to install SIMS SQL Server parts on this machine it always copies the SIMS database and log files into the SQL Program folder on the C Drive. How do I get the SIMS installer to put its database and log files in the correct default locations as specified in SQL Server? Jon
-
This is going to be quite specific. I have a lovely flash animation that someone has made for me that does a sweep through a football line up. It allows me to pass the variables of the players to it via a single url using the pipe character to separate the names. I'm looking for a php script that can populate a database with the players for each years football teams in the positions (2 each for years 7,8 and 9 and general u13 u16 etc) and one that will generate the correct url for the flash depending on a variable passed to it (that corresponds to the team needed) via it's url. Wow that all sounds a little complicated but I'm hopeful that someone can help me with this flash url needs the following thetitle=Team Name thedate=A Date theplayers=RightForward|LeftForward|LeftMid|CenLeftMid|...etc then Subs
-
Hi all, I've been asked by a teacher to recommend some software she can use to teach her class about database forking. I'm aware there are various open source offerings out there such as SQL, etc., but I'm a bit concerned that this may be a little complex. Can anyone suggest anything fairly simple (and, surprisingly, preferably free) that I can have a look at? Thanks.
-
Longshot here, cannot find anything on Google.. Has anyone had the error message "Cannot find the template v2mudconnect." When you attempt to open the Database part of Textease? I cannot find the file in the installation folders or a location where the file should be! Any suggestions welcome.
-
Hi all I have a feeling that the answer to this is going to be far more complicated that I realise but ... Datahandling is often a difficult topic to teach and not helped by software that makes a mountain out of a molehill (IMHO). I know that Access is very powerful but is often a sledgehammer to crack a nut. Most pupils can get on OK with excel but it's difficult to edit single records or to create queries and reports. It occurs to me that if you could have a nice 'form' tool that connects to an excel back end then this would overcome some problems. Something cool may even offer xml conversion, searching and queries. Something really cool may allow multiple users to access a single excel file (or maybe connect easily to a SQL server) fo that you can have multiple input. Has anyone ever seem anything like this? Bob
-
I have created a database for cartridge stock at my school, (its a hot topic here at the moment with a lot of money being spent on printing) but I am having a few issues with Access queries. I have currently got a query which shows the cartridges in stock and how many eg Cartridge Stock --------- ------ 339 7 344 5 Etc I also have a table which shows the required cartridges (some of which wont show up on the stock list becuase the query only counts items in stock). Is there a way of combining the tables to show 0 stock on some cartridges without using VBA? Apologies if its not clear :s
-
Im having some trouble with a MySQL database that I've been using with an online application form i developed a few weeks back. I thought I had finished the form as i didn't have any errors until we have come to test it over the past few days. The problem is When 2 different users use the form, or the same user closes the browser and starts a new session, the newest data will overwrite all other data in each field across all tables. Also if one person is filling out the form and a second users then starts a few moments after, the first person is then referred to the beginning when they move forward a page as the data base has lost all previous information. you can see the form at www.moorpark.lancs.sch.uk/teachapp/ the pages go as follows with each step page running an included 'process' page default.asp step-2.asp -process-1.asp step-3.asp -process-2.asp step-4.asp -process-3.asp step-final.asp -process-4.asp if needed i can sort out some paste bins of the full page code. Thanks! I have just noticed i have missed a 'where' statment off the end of my sql syntax.
-
Hi everyone, Just started a new post at a school, looking to dig around some of the data held in SIMS to help senior level leadership. Is it possible to run reports or query the SIMS database directly without interfacing with the SIMS GUI? Right now my current workflow is to query the database using Reports -> Run Report and attaching a macro enabled excel file to manipulate data. I'm sure there's a more useful way to be doing this? I've seen some posts relating to CommandReporter, could anyone point me in the direction of some documentation for this? Thanks for your help!
-
Database Manager required SN6, Wiltshire / Oxfordshire For the right candidate this role can be considered as either full-time or term-time only position FTE £25,000 - £30,000 Closing date 1st Feb, interviews 12th Feb, start ASAP Full details: Eteach - Database Manager 621343 -
I've been forced by Eset to migrate the virtual appliance (centos). This is something in years of ownership I've not been required to do before.. The push to the cloud solution is pervasive, the nomenclature is misleading. it took 3 attempts at reading guides, not understanding the nomenclature to find out what was required or the problem was. I now know that the upgrade involves me creating a new virtual machine, the instructions are spartan and not thorough. They tell me to make a new machine and spec the gen and ram but they don’t tell you to use the provided VHDX… I guess obvious but these are instructions not vague guides. Their support said they expected users to be familiar with hyperV! I thought I was going crazy, missing a step! Got a new problem, can’t log in to new VM, can’t find the answer, ask again tech support… article, great… Article says what the issue is and how to fix, type in the instruction “blah blah blah”…. Where? How? Again No Details…just assumptions. Terminal on the VM, nope, no option, SSH.. maybe but won’t accept credentials… reset credentials.. complexity not met?!?!! (fine) too short 18 or more chars….FFFS.. fine.. (existing creds just created 30 minutes ago didn’t meet these either but FML I guess.) Finally login as Admin… you need to be root to make these changes…… buttt clench. Root access denied.. access denied…. FFS.. more reading “root can’t use SSH” FFSS SFGSFS. This is why FULL instructions are needed! I hate ESET! I’m not renewing, this blows.
-
Hello All, I want a really simple system whereby Heads of Faculty respond to two questions for each Yr Group: ........Data Verified......Data Validated Y07........Y/N.......................Y/N Y08........Y/N.......................Y/N Y09........Y/N.......................Y/N Y10........Y/N.......................Y/N Y11........Y/N.......................Y/N I want to see a summary of this aggregated data across the facuilties so I can easily identify where the 'NOs' are. Some simple interface that all users can access at the same time is required. My question is, how would you achieve this? Thank you!
-
We are looking to appoint a Data Manager, with some experience of SQL and Management of Information Systems (in our case, iSAMS). Closing date is Monday 22nd June, and the person spec and further details can be found here: https://www.solsch.org.uk/vacancies Salary depends on qualifications and experience, but up to 35K
-
Data Manager, Cambridge, up to £35.8k, closes 14 July 2016
dgb posted a topic in Educational IT Jobs
Hello EduGeek Community We have on offer the job of Data Manager at The Leys School in Cambridge. The current role incumbent is moving on to a bigger role, and we are ideally looking to fill the role by the start of next academic year. Because of the time of the year, the recruitment drive is on a very tight timeline, and the closing date for applications is 14 July. If you know anyone who may fit the bill, please forward! In a nutshell, this is the database expert role within a team of 5, high on technical expertise, and with good working relationships both internally and with our user community. Our primary MIS is iSAMS. The job advert is here: http://www.theleys.net/userfiles/leysmvc/Documents/About-Us/Vacancies/Data%20Manager%20Advert%20July%202016.pdf The person specification and application form are linked here: Vacancies | About Us | The Leys School Cheers Damian -
Hi, have moved SIMS and FMS databases onto a new server OK, but am now wondering what the correct process for moving a DISCOVER database is. Have tried to attach the database using dbattach, but it just complains the ldf log file is missing, presumably because the file name is discover_log.ldf and not discover.ldf? Renaming and trying again produces a different error. I have tried to transfer data into a new DB, as if it was a fresh install, but at the moment the Discover Configurator is sat at waiting for service to respond. I am not sure if this is a separate issue or if something in the SIMS database from the old server already references a discover database and that's halting it. What's the correct procedure here?
-
Hi all, First post, so thank you for welcoming me. I am a scheduler in a big International school that is running Nova T6 and Isams (i.e not Sims!). i have just finished the schedule (well that is what one always believes until the proverbial fan is being hit). I would like to get some custom data report that is not built in. I KNOW there must be a SQL or MYSQL database behind Nova... I just can’t figure out how I can access and query it. Is there any way to get any access to the backend? Again, this is a Nova T6 standalone installation on a Windows 10 VM and I do not have access to Sims. Any help appreciated, Alain
-
using local sims with full SQL.. I was wondering how fast it should be. 1000 pupils big.. it takes 2-3 seconds to get a list of pupils from the search and about 3-4 seconds to bring up their record.. Not bad, Not great. I was going through student records and it feels so much slower that the numbers show. any pro tips for making it faster? 8gb ram 4 cores of xeon 4110, full sql. 6gb database. on a dell raid 6 direct sas.
-
[sims] Exporting Students to CSV - Header Names / Sample Data?
danmace posted a topic in MIS Systems
Hi All, I'm building a web and mobile app for my school that will require an import of SIMS data in a CSV file - that's the easy part!!! Trouble is, I don't have access to SIMS or a test / sample file - basically containing the header names like "DOB" or "Forename" etc. I was just wondering if anyone had a sample file or if anyone could give me a blank file? (just headers included) Thanks, Dan -
Hello Guys, I am planning my summer holiday project of moving our existing SIMS server to a completely new fresh install on Windows Server 2016 and onto a new piece of hardware. The SIMS server is currently joined to our old ADMIN DOMAIN and I will be putting the new server on our curriculum domain, with a different server name. So, today I have being playing in a test environment. I got the installable version of SIMS for Capita, and I installed it on Server 2016, and upgraded SQL from the express to our licenced edition due to the size of our SIMS DB. As I was installing SIMS, I told the installer I didn't want to create a DB, and that I would mount one later. After the SIMS 2013 Installable version installed, I ran the 2018 Spring Upgrade to updates the file server to the new files, and our current live SIMS DB is on Spring 2018. I used DBAttach to restore a SIMS DB from a backup, I copied our latest backup file from our live SIMS server onto the new test one which ends in a .bak file. It restored, but error-ed regarding creating SQL User Logins for all my users. I opened SIMS, and I couldn't login, just get Wrong Username/Password. I do apolagise, I am completely new to SIMS and my knowledge is limited, which is why I am experimenting now and documenting as I go along. Any help or advice is greatly appreciated. Many Thanks James
-
Hi, We may have to merge administratively with the school next door in the near future. MIS data will have to be merged as well. School A is on SIMS and school B is on CMIS. The scenarios as far as I can see are: School A keeps SIMS and school B moves over to SIMS, school B keeps CMIS and school A moves to CMIS or both schools keep their existing MIS and just carry on as they are (there won't be too much cross over in pupils between sites - it'll pretty much carry on as it is for the time being with pupils still going into the same building they've always used). Assuming the first scenario, would the data from CMIS (school B) be able to be merged into a new SIMS database along with the existing SIMS data (from school A)? I assume historical data for analysis will be required so a new blank database from scratch will not be the preferred solution here (I know we could give access to the old database(s) but the ideal solution is to have all previous data available). A name change may take place and the possibility that a new DfES number will be assigned means that a patch from Capita may be required. Does anyone have any experience of this scenario and know the pitfalls we may encounter (apart from the obvious timetabling and admin ones)? Cheers HBJB
-
Hello, all.. I've had a search through the forum and haven't noticed anyone talking about this specifically, but I could be wrong (it's one of THOSE days already!!).. I'm hoping (desperately) to try to catalogue the network cabinets and hardware in our school. I currently have the following information: 1. Excel sheet of all network points across the school, listing each point and which room it's in 2. Excel sheet of all PCs/printers (inc model/serial) by network name, listing which patch point they're connected to 3. Excel sheet of all cabinets, listing Cisco switches and which patch point plugs into which switch port 4. Excel sheet of Cisco switches listing which port is configured for which VLAN Is there some clever way I can get all of this information into one easy to lookup form? I'm thinking of things like: Look up PC123 and see that it's an HP DC7600 serial number 12345 which connected to wall point A/1/12 which is connected to Cisco switch 10.130.1.12 port 11 which is on VLAN 10. Kind of idea I don't much care if it's in Excel or not - that was just the original format I typed the data into. Is there some kind of application out there which might do this for me? (before I start dabbling in code myself - never pretty!) Cheers, Gerard
-
[fog] PXE Boot Menu Password Causes Failure to connect to DB
mpmackenna posted a topic in O/S Deployment
So my installation of FOG 0.28 on Debian Lenny was working just great. I decided to set passwords in my PXE boot menu options in the GUI. From what I understood you had to do this before you can use the "Quick Image" option on the boot menu. I was also interested in setting a passwords on the registration options in the menu. So I went to the Other Information, PXE Boot Menu, section and entered a password (same one I use for the GUI web interface login) in to all the fields on that page. After I applied those settings my log files are all showing the same line over and over. I tried going back and setting the passwords to blank again. I also tried getting the password from the config.php file that is used for FTP/TFTP and putting that in the Master Password field. I also rebooted the box just for kicks. None of this is undoing the problem that setting a password in the PXE Boot Menu seems to have caused. Any ideas on how I can further troubleshoot this issue would be greatly appreciated! Thanks, Mike
.thumb.jpeg.c4b2ea4e027981376480a5ab518033b7.jpeg)
