Saturday, August 3, 2013

[SQL 2012] sql server Merge Replication

[SQL 2012] sql server Merge Replication

sql server Merge Replication

Posted: 03 Aug 2013 01:21 AM PDT

I have found a couple of blogs on Merge Replication, but, wanted to ask if anyone has a blog or site they would recommend about Merge Replication.Thanks in Advance

SSIS, bulk import with ODBC

Posted: 02 Aug 2013 07:58 PM PDT

Hi all,First of all if I am posting this in the wrong forum my bet didn't see any correct forum for 2012 business intelligence.Let me explain our scenario:We are running an SQL Server 2012 and we run an import daily from and progress database to this SQL Server. However the bulk import from the SSIS package is very slow. What we do know:- Recreate the table with indexes and fields etc.- Import with bulk import- Delete the old table and rename the newly imported tableHowever the total time of importing is around 9 hours each day and then we are not importing all of the tables. Our main problem is one table is over 3 million rows large, and the import time of that table alone is around 3 hours. In my opinion that can go faster and better but I simply don't know how to achieve that...Is there a better practice to increase the speed of the bulk import so that the total import time gets faster?One thing maybe that can be a problem the progress database where the data is been extracted is an read only database we can't directly input data in to that database (Only with our application). So changes to the database are not allowed.Does anyone have tips to increase the speed of our SSIS package so our import runs (much) faster?Thx in advance!

Upgrading to 2012 from 2008R2 on an active/active cluster; named instance on each

Posted: 02 Aug 2013 07:27 AM PDT

So I've read about upgrading to 2012 on a dual instance active/active cluster. They say it is best to failover 1 instance to the other node and then do both instances on the passive node. THEN to failover the 2 active to the passive. This caused us an issue when upgrading from 2005 to 2008R2. Is it different in 2012? Is there a difference between "move services to another node" and "simulate failover"? Testing in about an hour in a sandbox, but I'd like feedback from others.

Mapping Dissimilar Data

Posted: 02 Aug 2013 10:35 AM PDT

For a busy OLTP application, what is the most efficient SQL method/process/tool/technique to map two dissimilar databases in real time? Queries from a new application need a homogenous interface whether connected to an old, inefficient legacy DB or to a new one with different structure. Is this what SCHEMABINDING does?See attached diagram.

how to uninstall SSIS Package in integration Service catalog.

Posted: 02 Aug 2013 03:33 AM PDT

Hi - i experiment creating a SSIS Package to process the cubes using Tata Tools. when I built the project, it create an "Intergration services project deployment file". I executed that file to deploy the SSIS package to the SQL 2012 Integration Service Catalog ( it ask me to create a new catalog name SSISDB and I did).After the deployment, I saw under Integration Service Catalog has to SSIS package.. but I also see the SSISDB database also create plus under SQL server Agent Job, there is an item for "SSIS Server Maintenance Job.Now my question is..I dont want to use this SSIS package any more, How do I uninstall all the SSIS package and everything that create by this deployemnt.Please advice. Thanks,Dee
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog