in 2016 they work fine - I have a DB where most of of the tables have a CCI's and no issues with them.

but in compat 2012 .... test it...

• This reply was modified 5 years, 9 months ago by frederico_fonseca.

Mike - this is shown on this site - not on any email I get

google for "winevents load to sql server" and you will find a few examples of how to do it

I do think it is very clear that it is free. And it is the vendor you should be asking in the first place.

https://zappysys.com/products/ssis-powerpack/compare/

you have the wrong order there

and 2 servers mean 2 different ip's and 2 different names so they can be alive at same time.

keep old server with old name

1 -...

• This reply was modified 5 years, 9 months ago by frederico_fonseca.

you need to use the output clause

With ProductName(ProductID, Description)
AS
(

    SELECT ProductID, ProductName
    FROM dbo.Products

)


INSERT INTO ProductName     ...

Having said this in my shop some of the teams do do some level of code review - and...

ahhhh... who will code review my SP with 10k lines ..

• This reply was modified 5 years, 9 months ago by frederico_fonseca.

could be a bug - but it is also how ADR / PVS works.

look at the troubleshooting section of https://docs.microsoft.com/en-us/sql/relational-databases/accelerated-database-recovery-management?view=sql-server-ver15 - DMV's will probably help you determine what is causing...

you will need mapping tables for sure - with source ids and new id's

how many will depend on your system.

so initial migration step is to do the "base" tables e.g....

if both use the same ERP system maybe the vendor has a tool that will "merge" both into a single instance - have you contacted them about it?

And not all...

what have you googled and what have you found out that you didn't understand?

plenty of info out there and we are not here to do the search for you.

and out of curiosity why are you still using something that requires you to connect to Integration Services? in 2016 you should be using SSIS Catalog which does not require...

https://www.ibm.com/support/pages/informix-client-software-development-kit-client-sdk-and-informix-connect-system-requirements?mhsrc=ibmsearch_a&mhq=informix%20client%20sdk

but I think you need a login - possibly under the contract your company has for Informix

or you may be able to use a third party driver - possibly https://www.progress.com/odbc/ibm-informix

you need to understand how filtering can be done - and the order it happens. and the difference between being a inner or a outer join

• Join - indicates how...