StrataFrame Forum

How do I move a profile.

http://forum.strataframe.net/Topic2363.aspx

By Keith Chisarik - 8/22/2006

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?
By Trent L. Taylor - 8/22/2006

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.
By Keith Chisarik - 8/22/2006

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.
By Trent L. Taylor - 8/22/2006

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.
By Trent L. Taylor - 8/22/2006

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.
By Keith Chisarik - 8/22/2006

Ok that is the piece I missed, thanks. Ill do the backup and restore since that is what I am most comfortable with.



BigGrin
By Trent L. Taylor - 8/22/2006

I just didn't want you wondering where your mappings went Smile