StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » How do I move a profile.

How do I move a profile.

Keith Chisarik — Tue, 22 Aug 2006 13:46:37 GMT

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?

RE: How do I move a profile.

Trent L. Taylor — Tue, 22 Aug 2006 13:46:37 GMT

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

RE: How do I move a profile.

Keith Chisarik — Tue, 22 Aug 2006 13:43:19 GMT

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

:D

RE: How do I move a profile.

Trent L. Taylor — Tue, 22 Aug 2006 13:39:20 GMT

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.

RE: How do I move a profile.

Trent L. Taylor — Tue, 22 Aug 2006 13:37:56 GMT

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.

RE: How do I move a profile.

Keith Chisarik — Tue, 22 Aug 2006 13:35:37 GMT

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.

RE: How do I move a profile.

Trent L. Taylor — Tue, 22 Aug 2006 13:33:30 GMT

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.