Date: Fri, 29 Mar 2024 07:16:50 +0000 (GMT) Message-ID: <316934446.593.1711696610438@ip-172-31-38-4.eu-west-1.compute.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_592_86538666.1711696610434" ------=_Part_592_86538666.1711696610434 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
SQL Packager creates databases in a way that is compatible with = the database being packaged. For example, if the database resides on the SQ= L 2000 platform, the database scripts will be created in the SQL 2000 synta= x. If Packager is configured to create an "upgrade" package, then it can ch= ange the T-SQL syntax so that it conforms to the target server platform.
To create a database package using the SQL syntax different from the ver= sion of the source database, it is necessary to have an installation of the= version of SQL Server that you would like to deploy to.
SQL Packager will produce a script to create all objects in dependency o= rder, and use syntax that is compatible with the target server platform.&nb= sp;
Where possible, new features such as CLR assemblies are filtered out bec= ause they are incompatible with SQL Server 2000. Sometimes this is not poss= ible, for instance if a stored procedure relies on a CLR function. Since th= e function cannot be created, the stored procedure cannot be successfully s= cripted. Analyzing your databases for these conditions first is recommended= .
If you continue to experience problems, please contact Red Gate Su= pport.