How do I install to SF to SQL 2008 R2?


Author
Message
Michael Reese
Michael Reese
StrataFrame User (413 reputation)StrataFrame User (413 reputation)StrataFrame User (413 reputation)StrataFrame User (413 reputation)StrataFrame User (413 reputation)StrataFrame User (413 reputation)StrataFrame User (413 reputation)StrataFrame User (413 reputation)StrataFrame User (413 reputation)
Group: StrataFrame Users
Posts: 235, Visits: 1.6K
I currently have SQL 2005 and 2008 R2 side by side on a Vista ultimate 32 bit environment and  would like to install the SF DB environment to SQL 2008 R2 only?

Michael
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Michael.

If I understand, you would like to move the SF database to your SQL 2008R@, right? If so, make a backup of the SF database on your SQL 2005 first, for security. Dettach the StrataFrame database from your SQL 2005. If you want it on the default place for SQL Server 2008R2, copy the StrataFrame.mdf and the StrataFrame_log.LDF to your "C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA". Then, log into your SQL Server 2008R2 and attach the StrataFrame onto it.

After that, in the Visual Studio IDE, go to the StrataFrame menu and choose Database Connection. Select the current StrataFrame Data Store, Edit it and use de Database Connection Wizard to connect to your StrataFrame database attached to your SQL Server 2008R2.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search