Transfering projects

Hello there!

Today let’s talk about how to transfer your project to different servers.

There are two ways to do that:

First way) You need to create the source and destination project source in MicroStrategy Desktop/Developer.

You can do that by opening MicroStrategy Desktop/Developer, clicking on Tools -> Project Source Manager -> Add

pic1

pic2

And then, add the source server and add the destination server.

You can do that using 3-tier or 2-tier, is up to you.

Then, go to Schema -> Duplicate Project

pic3

MicroStrategy will ask you the source connection and which project do you want to transfer, and then, it will ask you the destination server.

You need to provide the Administrator user to do that.

pic4

pic4

pic4

Give the name to the destination project name:

pic4

Choose the languages that you want to transfer to the destination.

pic4

In the window below, you have to take care! Read every option before hit the next button. One option that I usually uncheck is the users and groups to copy. I never intent to transfer the users from my source to my destination, so in that case, just select NONE in Users and groups to copy.

pic4

Also, read all options in this windows to make sure you really want that. I usually don’t do nothing on this window.

pic4

And the next windows is going to ask you about the logs. Change the directory to one that you can write. Sometimes we can some errors because your windows/unix user don’t have permission to save files on that default directory.

pic4

And then, hit the finish button. Wait a little bit to complete, and you will have the project transfered to your destination.

Second way) In the case that you can’t reach the destination server.You can create a mdb file, for example, create the DSN to this mdb file, create a Metadata shell and create a 2-tier connection to this database in MicroStrategy Desktop/Developer. Please refer to the First way to know how to add a new connection.

Then, proceed exactly how I explained to you in the Fist way, but at the end, you will have your project inside that mdb file. Then, go to your destination server, create a 2-tier connection to this mdb file and duplicate the project that is inside this database to your destination server.

So, reviewing it:

1. Create an empty mdb file or an empty database in SQL Server, Oracle, etc…
Go to configuration wizard and create a new Metadata shell for the mdb file.

2. Create a DSN connection to this database;

3. Create a 2-tier connection to this database;

4. Use this 2-tier database to be the destination of your duplicated project;

5. Copy and paste this database to the server that you want to receive this project;

6. Create a DSN connection to this database;

7. Create a 2-tier connection to this database and duplicate the project to your server;

That’s it.

Hope it helps!

God bless you!

2 thoughts on “Transfering projects

  1. Bogdan

    Hi, if you choose the second way to duplicate the project I think you have to create the metadata shell after creating the mdb file. Please correct me if I’m wrong.

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s