|
| | | 
Advanced StrataFrame User
 
Group: StrataFrame Users
Last Login: Today @ 12:47:59 AM
Posts: 622, Visits: 19,141 |
| | I have metadata in the Strataframe Data Store on my local PC (.\sqlexpress) how can I move these profiles to my newly deployed development server SQL 2005 Enterprise Edition? |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| | There are several things you can do here. The easiest would probably be to use the SQL Server Management Studio tools to copy the database from one to another. You can also manually copy and mount the StrataFrame.mdf and associated files. |
| |
| | |
Advanced StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 12:47:59 AM
Posts: 622, Visits: 19,141 |
| | I created a new profile on the new server and imported my existed database metadata from the .pkg file. Seems to have worked great unless I missed something. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| | You could also backup and restore. If you backup the databases to file, you can take those backup files and restore them on the new server. 
|
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| | Yes, that will work also. But if you had any BO Mappings in the StrataFrame database, these will not have come accross...just FYI. If all you had was meta-data, then yes, you are good to go. |
| |
| | |
Advanced StrataFrame User
Group: StrataFrame Users
Last Login: Today @ 12:47:59 AM
Posts: 622, Visits: 19,141 |
| Ok that is the piece I missed, thanks. Ill do the backup and restore since that is what I am most comfortable with.
 |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| I just didn't want you wondering where your mappings went  |
| |
|
|