To create the linked server, you need to install AS/400 client access on the SQL Server instance, this will install the Client Access ODBC provider, and then you need to create an ODBC for connecting to AS/400, ODBC needed to create the linked server.Ĭreate a DNS record on your DNS servers for your AS/400. Cleaning the data is difficult on the SQL Server side on those situations, cleaning must be done on the AS/400 side. English-Russian SQL Server dictionary > SQL Server Enterprise Edition. Sometimes some strange characters come with the data from DB2 tables, characters that are not recognized just viewing the data, but are there and can affect calculations. If you are planning to update data (insert/update/delete) on AS/400 from SQL Server, you need to enable journaling on AS/400. Then I read that set of tables from SQL Server. For that reason, I created a set of tables without indexes on DB2 just for the ETL process, refreshing them over night. After checking all rules for edition upgrade, review the summary information and click Upgrade to. Select the existing SQL Server instance for which you are going to change product key. Accept the license term and click Next to proceed. Enter the new product key and click Next. About comparing Enterprise Edition vs Standard Edition, please see the following links:Ībout the linked servers to AS/400, I remember I had some issues with tables on DB2 that have indexes created. Under the Maintenance tab, click on Edition Upgrade as shown below.
0 Comments
Leave a Reply. |