InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumMon, 08 Jun 2026 23:45:31 GMT20http://forum.strataframe.net/FindPost12396.aspxHi all,</P><P>When I started with SF I had installed MS-SQL Express 2005, now I want to install the Developer Edition of SQL 2005, and remove the Express version in my dev computer.</P><P>Is there something I should be doing with the databases I already have in the Express version before or after installing the Developer edition?&nbsp; specially the SF database.&nbsp; I just don't want to mess up my SF installation, nore loose any project's database currently on the Express version before removing this version and installing the Dev edition.</P><P>Thanks!Tue, 06 Nov 2007 09:11:02 GMTEdhy Rijohttp://forum.strataframe.net/FindPost12482.aspxROFL...yup, I have been there before too :DTue, 06 Nov 2007 09:11:02 GMTTrent L. Taylorhttp://forum.strataframe.net/FindPost12476.aspxAhmen brother!Tue, 06 Nov 2007 09:03:30 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost12470.aspx[quote]... just before a lighting strike takes out my ISP, so I'm sitting in the dark with my UPS beeping at me, telling me my battery is about to die... and my wife is upset because she told me dinner was ready 3 hours ago :pinch:[/quote]</P><P>Apparently an upset wife has amazing powers! Sending a lightning to make you stop working seems to be a proof of it... :w00t:Tue, 06 Nov 2007 06:41:51 GMTIvan George Borgeshttp://forum.strataframe.net/FindPost12467.aspx[quote][b]Greg McGuffey (11/05/2007)[/b][hr]... and my wife is upset because she told me dinner was ready 3 hours ago :pinch:<BR>[/quote]<P>Hummmm, that sound pretty familiar :hehe:Mon, 05 Nov 2007 19:46:09 GMTEdhy Rijohttp://forum.strataframe.net/FindPost12465.aspxYeah, I had an experience like that once, everything just working the first time...I think...been a while...hard to remember :unsure: ... Usually, I'm seeing red (SF error dialogs), blank screens, SQL server is screaming at me to find the log file, I'm getting confused because I'm remoting into SQL via a term server on my local switch box, so I'm entering sql commands into my email and typing memos in SSMS, just before a lighting strike takes out my ISP, so I'm sitting in the dark with my UPS beeping at me, telling me my battery is about to die... and my wife is upset because she told me dinner was ready 3 hours ago :pinch:<br> <br> ;)<br> <br> I'm glad you got it running w/no problems! :D<br> <br>Mon, 05 Nov 2007 18:29:21 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost12464.aspxGlad to hear that Edhy! :cool:Mon, 05 Nov 2007 16:38:09 GMTIvan George Borgeshttp://forum.strataframe.net/FindPost12463.aspxHi Greg, Ivan,</P><P>FYI, I installed Developer version of MS-SQL with not problem, detach all databases (including SF) from Express version and attached them to the Dev version without a problem, of course SF connection manager fixed the new connection and everything works fine.</P><P>Thanks again to both of you for your inside experiences.&nbsp; :w00t:Mon, 05 Nov 2007 16:33:50 GMTEdhy Rijohttp://forum.strataframe.net/FindPost12422.aspxAny time :cool:Mon, 05 Nov 2007 09:35:12 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost12415.aspxHi Greg,</P><P>Thanks for the details, I did not know any of that, so I do really appreciate the details in your post. :PMon, 05 Nov 2007 09:06:52 GMTEdhy Rijohttp://forum.strataframe.net/FindPost12410.aspxI'll add to Ivan's comments (all good), having done something like this...<br> <br> - If you are simply replacing the default instance of SQL Server with another default instance (I.e. you uninstall express, then install developer version), and you use the same user/password (or use windows auth) between the two installations, you'll be able to use the attached db no problem. If any of this is different, you'll need to change the database connection for SF in VS and you'll need to reconfigure you projects the business mapper.<br> <br> - If you're not using windows auth (you're using SQL auth), then you'll need to create the user name(s) in the new instance and after you attach your database, delete the user(s) form the database and readd them using the newly created users. I.e. if you are attaching to the StrataFrame db as edhy in SQL Express, the process (related to this issue) would be to: detach the StrataFrame db, uninstall SQL Express, install Developer version, attach StrataFrame db, add a login for edhy to SQL server, delete the edhy as user from the StrateFrame db, add edhy back as a user of StrataFrame. Remember to keep the user's passwords the same (see above). This only applies to sql auth (non sa users...if you are attaching as sa, then you don't need to do this). This is needed because SQL Server actually uses an internally generated GUID for each user. When you move the database (by detaching/attaching), the database is tracking the GUID. So even though the user name and password match in the new db, the GUIDs won't.<br> <br> - If you use VS when the StrataFrame database is unavailable (like in the middle of the database switcheroo), expect it to open very slowly and expect any work in form designers to be very slow, even if you are working on non SF projects.<br> <br> - If you detach your databases and move them to new locations, you can sometimes have trouble attaching them through either SQL Server Management Studio, or worse, it does something unexpected. When you attach via SSMS, it expects the log file to be where it was when it was detached. So, if you move the main mdf file, one of two things can happen, depending on what you do with the log file. If you leave the log file in the old location, it will be used (typically occurs if you just copy the mdf and ldf files to the new location). This is especially bad if you copied the ldf file (not moved it), as you might not catch it and back up the wrong log file. If you moved the ldf file or deleted it, then the attach will just fail, saying it can't find the log file (even though the log file is sitting right there next to the mdf...sigh...you'd think they might be able to use relative paths). If you run into this, use this sproc to attach the file:<br> <br> [codesnippet]exec sp_attach_single_file_db 'dbName','c:\FullPath\to\database\file.mdf'[/codesnippet]<br> <br> This will create a new log file if the one referenced within the mdf isn't found. Typically, I'll follow this process to move/rename an mdf: backup the database, open the properties to the database I'm about to detach to make sure I know where it is ( :blink: ), detach it, delete the log file (just did a full backup, so this is OK), move it, run the above sproc, mess with users (see second item), update configuration of VS/BO Mapper if needed (see first item).<br> <br> You may have already known all of this, but all of these have bitten me, so I thought if you didn't know, it might save you a bit of pain :DMon, 05 Nov 2007 08:46:42 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost12409.aspxHi Ivan,</P><P>Thanks for information, will try that today.Mon, 05 Nov 2007 08:45:27 GMTEdhy Rijohttp://forum.strataframe.net/FindPost12404.aspxHi Edhy.</P><P>[quote]Is there something I should be doing with the databases I already have in the Express version before or after installing the Developer edition?&nbsp; specially the SF database.[/quote]</P><P>Yes, you should copy it to your new SQLServer. I guess the simplest way would be to "Detach" it from your SQL Express, copy it to your new folder, if you wish, and then "Atach" it back to your other SQLServer. Ah, and don't forget your project's databases too, and the StrataFrameSample, as it will be used to run the samples when you need.</P><P>Hope it helps.Mon, 05 Nov 2007 05:09:25 GMTIvan George Borges