Transfer SqlServer Objects

gravatar

John Minkjan

Demo on transferring database objects between MSSQL environments

published 10.09.12

last updated 10.09.12


Share

Tags

  • TransferSqlServerObjects
                            



<Biml xmlns="http://schemas.varigence.com/biml.xsd">
	<Annotations>
		<Annotation>
			File: Transfer.DataBase.Objects.biml
			Demo on transferring database objects
			between MSSQL environments
			Enviroment:
			DB: MS-SQL2012
			BIML: 1.6 VS2010 BIDS Helper
			(c) John Minkjan biml101.blogspot.com
		</Annotation>
	</Annotations>
	<Connections>
		<SqlServerManagementConnection
            Name="SSMCLocalHostMSSQL2012"
            SqlServerName=".\MSSQL2012"
            UseWindowsAuthentication="true"></SqlServerManagementConnection>
	</Connections>
	<Packages>
		<Package Name ="Transfer.DataBase.Objects" ConstraintMode="Linear">
			<Tasks>
				<TransferSqlServerObjects
                    Name ="TransferSqlServerObjects"
                    SourceConnectionName="SSMCLocalHostMSSQL2012"
                    SourceDatabase="AdventureWorks2012"
                    DestinationConnectionName="SSMCLocalHostMSSQL2012"
                    DestinationDatabase="AdventureWorksDW2012"
                    DropObjectsFirst="true"
                    CopyData="true"
                    CopyAllTables="false">
					<Annotations>
						<Annotation>
							Notation for tables:
							[schema].[TableName]
							(including bracktes}
							Target schema must exist!
						</Annotation>
					</Annotations>
					<Tables>
						<Table>[HumanResources].[Department]</Table>
						<Table>[HumanResources].[Employee]</Table>
						<Table>[HumanResources].[EmployeeDepartmentHistory]</Table>
					</Tables>
				</TransferSqlServerObjects>

			</Tasks>
		</Package>
	</Packages>
</Biml>


                        

File: Transfer.DataBase.Objects.biml; Demo on transferring database objects between MSSQL environments Enviroment: DB: MS-SQL2012 BIML: 1.6 VS2010 BIDS Helper; (c) John Minkjan biml101.blogspot.com;Also published on http://biml101.blogspot.com/2012/10/biml-transfer-database-objects.html

You are not authorized to comment. A verification email has been sent to your email address. Please verify your account.

Comments

There are no comments yet.