SQL Server integration/interoperability

MUST READ Moving data between MySQL and SQL Server TIP - If your objective is to move data back and forth between MySQL and SQL Server, you must take into account data typing restrictions, normalization standards and migration tools. Generating multiple flat files from a single flat file source EXPERT ANSWER - I have a single flat file source containing 1 million (changeable) rows. I want to generate multiple flat files, each containing 30,000 rows. The naming convention for the destination file could be anything as of now. The ... SQL Server consolidation pros and cons TIP - You may want to consolidate SQL Servers to reap the reduced licensing, hardware and administrative costs, but there are various "gotchas" to consider before making such a move. FAQ: SQL Server 2005 features and functions FAQ - SQL Server 2005 is full with new features and functions. Get the answers to 10 frequently asked questions on the minds of DBAs and developers about major DBMS changes. Connecting a Oracle9i Forms application to SQL Server EXPERT ANSWER - I am currently working on a project with Oracle9i Forms at the front end and Microsoft SQL Server at the back end. Could you please recommend the necessary steps to connect an Oracle Forms 9i application with a SQL Server ...

EXPERT TECHNICAL ADVICE: 1 - 3 of 44

SQL SERVER INTEGRATION/INTEROPERABILITY EXPERTS
			Joe Toscano SQL Server Business Intelligence consultant/Instructor ASK A QUESTION		Mark Kromer Technical Product Manager ASK A QUESTION

	How to create a SQL Server linked server to DB2 Submitted By: SearchSQLServer.com | 20 Aug 2008 TIP - Many SQL Server environments run DB2 servers, too, and often the two servers must be linked. Here's a step-by-step process that shows how to create a SQL Server linked server.

	Performance tuning for SQL Server 2005 and Exchange running on SBS 11 Mar 2008 EXPERT ANSWER - To avoid performance problems when running multiple instances of SQL Server 2005 with Exchange on Windows SBS, refer to these expert best practices.

	Custom VB.Net scripting in SQL Server Integration Services Submitted By: Robert Sheldon | 18 Dec 2007 TIP - Add a Script component and custom Visual Basic.Net (VB.Net) scripting to SQL Server Integration Services (SSIS) packages to get the full power of .Net.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER INTEGRATION/INTEROPERABILITY

REFERENCE & LEARNING: 1 - 3 of 11

	Top 10 SQL Server Integration Services (SSIS) and DTS tips SearchSQLServer.com | 15 Jun 2008 TOP 10 TIPS - Top SQL Server Integration Services (SSIS) tips from migrating and running DTS packages, to SSIS debugging, maintenance and programming in SQL Server 2005.

	Export SQL Server data to an Excel file using SSIS and Visual Studio Jayaram Krishnaswamy | 08 Apr 2008 TUTORIAL - Here are seven steps for designing a SQL Server Integration Services package using Visual Studio and exporting data from your SQL Server table to Excel.

	SQL Server Integration Services how-to Heidi Sweeney, Associate Editor | 30 Jul 2007 LEARNING CENTER - SSIS makes managing SQL Server data a more flexible task. Get specifics on migrating from DTS and building SSIS maintenance plans in this collection of expert advice.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER INTEGRATION/INTEROPERABILITY

NEWS: 1 - 3 of 7

	PostgreSQL vs. SQL Server: PostgreSQL is right for the Microsoft stack SearchOpenSource.com | 16 May 2006 ARTICLE - Is OS database PostgreSQL ready to replace Microsoft's SQL Server in the enterprise? Web application developer and author W. Jason Gilmore tackles the question in this column.

	Microsoft unwraps its JDBC driver for SQL Server SearchWinIT.com | 18 Jan 2006 ARTICLE - Microsoft is polishing its interoperability story with the general release of a driver that links J2EE/Java applications on any platform to a SQL Server database.

	Are single-platform databases in your future? SearchWinIT.com | 12 Dec 2005 ARTICLE - As DBs become more alike and they all add the capability to pull data from multiple sources, at times it's simpler to deal with problems by moving everything to a single platform.

	VIEW ALL NEWS ON SQL SERVER INTEGRATION/INTEROPERABILITY

DEFINITIONS: 1 - 1 of 1

	CORBA 24 Mar 2003 WORD - Common Object Request Broker Architecture (CORBA) is an architecture and specification for creating, distributing, and managing distributed program objects in a network. It allows programs at different locations and ...

	VIEW ALL DEFINITIONS ON SQL SERVER INTEGRATION/INTEROPERABILITY

	SEE ALSO - Topics Related to SQL Server integration/interoperability:  SQL Server installation, SQL Server replication, SQL Server database design and modeling, SQL Server performance and tuning, SQL Server Online Transaction Processing (OLTP), SQL Server backup and recovery, SQL Server clustering, SQL Server security, SQL Server availability, SQL Server data warehousing/business intelligence