I'm in the process of moving data from one database to another. Both are Microsoft sql 2005 databases. I planning on using SSIS to do this but have run into a problem. Since the source database uses int for its primary key and the destination database uses guid for its primary key how can I preserve relationships between tables.
I am fairly new to SSIS but feel comfortable with straight forward data transfer between tables. Any advice/help would be greatly appreciated.
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.