sybase sql somewhere – Migration tool from SqlAnywhere to MSSQL

Is there a migration tool that manages SAP SqlAnywhere 17 to MSSQL (all recent versions)?

I already know that Sybase to SQL Server Migration Help (SSMA) is available for a number of platforms, including Sybase ASE Not Compatible with the database previously known as Sybase SqlAnywhere and now named SAP SqlAnywhere. I have tried this, and it is not interested in using my SqlAnywhere ODBC driver.

Content Migration – Migrate SharePoint workflows using PowerShell

I migrate subsites with Export SPWeb and Import SPWeb to another site collection. However, I lose all OOTB workflows and SPD workflows. The SPD workflows exist and can be viewed through SharePoint Designer, but all links to the list / library are lost at the destination.

My request to all SP experts here – Is there a way to migrate the workflows through Powershell?

Migration – Can I disconnect Sharepoint 2007 databases from a SQL Server 2008R2 and connect to SQL Server 2014 without migrating Sharepoint?

I want to know if I can disconnect SQL Server 2008R2 Sharepoint 2007 databases (Windows Server 2008R2) and connect to SQL Server 2014 (Windows Server 2012R2) without migrating Sharepoint?

Assuming it is possible, I would do the following:

  • Stop Sharepoint Services and IIS on my WFEs
  • Disconnect the SharePoint DBs from SQL SERVER 2008R2
  • Attach all Sharepoint DBs to SQL Server 2014
  • Restart all Sharepoint services and IIS

Does anyone have any recommendations?


Automate local migration from Outlook to Exchange for 40 users

Right now, I'm working on a site that has about 40 users, each with their own local Outlook settings on their PCs (which are currently connecting to the mail server through POP / IMAP).

You have asked me to migrate all users to a cloud-hosted Exchange service.

I know how to manually export your local data to a PST and then reimport it into every Exchange account. However, this is a very time consuming process. Is there any way to automate this, even to the point where every user can do their own migration by simply clicking on some buttons or running a script?

After manually creating the users in the hosted Exchange environment, the following steps are required for each user:

  1. Open Outlook and do a complete export of all existing emails / contacts / calendars / notes / etc to the PST file.
  2. Close Outlook, go to "Mail" in Control Panel and create a new profile.
  3. Connect the new profile to the Exchange server by using the user's credentials
  4. Start Outlook with the new profile, import the previous PST file, and wait for it to sync to the server.
  5. (Optional) I think it would be nice if the autocomplete entries were kept as well.

I wonder if PowerShell can achieve this level of integration with Outlook.

I would be very grateful for any suggestions on how to do this, whether it's a script, an application, a batch file, and so on. This is certainly a common problem.

[WTS] Order Hostforweb Reseller Hosting – Unique Features | cPanel / WHM

For the webmasters who are looking for reliable Reseller hosting is the best solution.

HostForWeb, Inc Chicago is the leading hosting provider, providing reliable, scalable solutions for customers of all sizes and services. Located in the carrier neutral Equinix Chicago data centerHostForWeb, Inc. has access to all major carriers in Chicago without the need for a local loop. We founded this company with one goal: reliable hosting solutions coupled with excellent customer service.

Start your own hosting business!

With our tools, you can easily start your own hosting service with a free, easy-to-use WHMCS billing platform cPanel / WHM control panel, Over 300 pre-installed popular apps and much more. Take complete control of your packages, set your own prices and let our anonymous servers guarantee that your customers never hear from us.

CHECK OUT Host for the web Hosting solutions for resellers :

HFW-0 retailers plan
Memory – 100 GB SSD
Bandwidth – 1000 GB
cPanel / WHM
Price per month – $ 24.95

HFW-1 dealer plan
Memory – 150 GB SSD
Bandwidth – 1500 GB
cPanel / WHM
Price per month – $ 34.95

HFW-2-dealer plan
Memory – 200 GB SSD
Bandwidth – 2000 GB
cPanel / WHM
Price per month – $ 49.95

HFW-3-dealer plan
Memory – 300 GB SSD
Bandwidth – 3000 GB
cPanel / WHM
Price per month – $ 69.95

HFW-4-dealer plan
Memory – 400 GB SSD
Bandwidth – 4000 GB
cPanel / WHM
Price per month – $ 89.95

Why choose us?

  • Self-healing hardware – We centrally store your cloud server without connecting to the cloud nodes it runs on and secure it through a seamless failover process. In the highly unlikely event of a node failure, your system automatically restarts.
  • Scale on Demand – Whatever computer resources you need (RAM / CPU / memory), we will make them available automatically when needed. Your website will never go down because of high traffic.
  • Fastest in the industry – Our network infrastructure is redundant, transparent and always available, offering you a solution 10x faster than the average dedicated server.
  • Free migration help – If you have an existing site with another hosting company, we'll be happy to take care of your migration process, for free. Our customer service representatives are available 24 hours a day, 7 days a week.
  • 24/7/365 customer service – We care about being available to our customers when they need us, not a moment later. No matter when you want help with your server, we are here – that is a promise.
  • Satisfaction guaranteed – We are sure that you will love our services, that we give you a 30-day money back guarantee. No questions asked.

We enjoyed a lot Growth over the yearsbut this goal has never changed. We can warranty No matter how much we grow or how successful we are, we are never led astray by our purpose. We owe everything to our customers and will continue to show our appreciation with our reliable and our solutions Top-of-the-line service,

Contact information:
Postal / transfer address: HostForWeb, 56 Leonard Street Suite 21A East, New York, NY 10013
For more contact information, visit:

With HostForWeb web hosting servicesHave industry-leading performance, security, performance and fault tolerance. We know that you deserve the best for your hosting. Why do not you pick us?


Design – Problems handling Stackholder with DB Migration for a Strangler migration

Background of the project

We are responsible for the migration of an over 10-year old legacy system (ERP). The reason for the migration is mainly related to business requirements and maintenance costs. Nothing new.

The problem

The CEO, who was also the database administrator who designed and created the database, says his database design is not corrupt and therefore not a destination for migration.

The software architect and I disagree with his statements. Some of the issues that we have addressed are:

  • Multiple tables use business keys as primary keys. Some of these buttons are texts and accept special characters like & # 39; # & # 39; and & # 39; / & # 39 ;.
  • Due to some issues in the past, some tables are used as Engine MyISAM, others use InnoDB.
  • Many tables have compound primary keys with two or more columns that make up the PK (one of the tables that make up PK consists of 9 different attributes!), But there is no reason to keep this design. A single column with automatic increment would be sufficient for most cases and justifications / explanations for the why were vague or absent.
  • There are several inconsistencies in the database, i. H.: Table father uses the attributes A, B, C, D and E as compound PK. Table Son has a FK from the Father table and replicates columns A, B, and C as a compound PK.

There are other reasons, but the above are the main reasons for the software migration process because they make the project more complex when mapping models and programming CRUD operations.

Please take into account that he is the CEO and currently he is also managing the DBA job, but he is completely out of the market as DB has been out of focus for several years.

The solution we accepted

We are migrating with a Strangler pattern so we can not make any structural changes to the database. The solution we found was to add a column that will be used as the primary key in the new software, and to transfer the responsibility for maintaining the PK of the legacy system to a particular service so that it will shut down after the strangulation is complete.

On the legacy side, we do not have enough resources to do the same thing. Therefore, we delegate the responsibility of updating the attributes used by the new software as PK using the pre-insert triggers and before updating to the database. Once the strangulation is complete, we only need to remove the triggers.

Not elegant (not to say the worst), this adds some workload to the server, but so far we have had no negative impact on the user experience.

The result

The CEO / DBA found our approach outrageous, but failed to clarify why he opposes it, except that he believes in his belief that his design is perfect and should be maintained.

What I'm looking for

References. To show as well as possible that he is wrong or maybe I am.

Since database is not our main focus, it is possible that the whole approach described above may be confused, but it is difficult for us to look for case studies or the like containing information on best practices for database migration with Strangler Pattern. So I came here looking for insights from specialists.

Please let me know if this is really not the place for this question.

The migration from MySQL to Oracle generates empty tables

I use SQL Developer to migrate a database from MySQL 5.7 to Oracle 18c XE. The problem is that the tables are created but empty, although I indicate that the data should be moved online. I also looked at the scripts and there is no data.

What I see in the log is DataMove.DISABLE_CONSTRAINTS_FAILED, How can I fix this?

These are the migration options:

Enter the image description here

8 – Creating Entity Migration Stubs for a Multi-Value Reference Field?

I need to import a group of authors as part of a content entity. It is an array in a JSON object with id / name. I have a content type field in Drupal to be a user reference that accepts unlimited cardinality.

First of all, I do not know these users in advance, no way to query them. So I can not just create a migration dependency and do it first. This seems to be a popular answer, but it does not fit with my use cases.

Second, I think you should be able to take over the source data and loop and create a user stub if they do not already exist. How you do that? If the user does not already exist, they should be created. If they exist, just search for the user ID and paste it into the target ID per line.

This is not the only place I come across that will have content related to content that I have to stub. I do not know the last content until I later do the migrations.

Is that even possible in D8?