Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can the SQL Profile created on one machine be moved or exported to another?

April 26, 2017exported Machine Moved profile sql

0

Posted

Can the SQL Profile created on one machine be moved or exported to another?

1 Answer

0

Posted

The short answer is no. The only exception to this is when you do a full database export/import. In this case, everything along with SQL Profiles will be imported into the target database. Moving SQL Profiles from one database to another, if it were allowed, will not necessarily produce the same execution plan in the target database as the source database. This is because SQL Profiles, which are statistics pertaining to a particular SQL statement, are very specific to the SQL statement and database environment, and unless both the databases have identical environments, moving SQL profiles between them will not produce the behavior you may be expecting, as we cannot guarantee that the optimizer will produce the same plan in the target database as the source database. This is why we only move SQL Profiles for full database exports/imports.