StrataFrame Forum / StrataFrame Database Deployment Toolkit / Database Deployment Toolkit (How do I?)

DatabaseMigrator reruns whole commands always

Luiz Lima — Fri, 12 Mar 2010 07:09:29 GMT

Hi,

I´m using DatabaseMigrator to deploy DB changes to a lot customers databases in the same server.
The problem is:
All commands are processed every time that I run the program, but I realized that it rans the same command already proccessed before like:

• 12/03/2010 09:56:02 -> The relationship 'FK_tb_ped_compra_tb_item_pec' was created successfully.
• 12/03/2010 09:56:09 -> The relationship 'FK_tb_tit_pag_tb_tit_pag_ccusto' was created successfully.
• 12/03/2010 09:56:09 -> The relationship 'FK_tb_tit_pag_tb_tit_pag_proj' was created successfully.
• 12/03/2010 09:52:50 -> The table 'tb_tit_rec' was successfully altered.

Other thing:

• 12/03/2010 09:52:42 -> The relationship 'FK_tb_tit_rec_tb_tit_rec_ccusto' was successfully dropped.

If DatabaseMigrator drop my FKs, what is happen if I run it over a DB with real data?

Tks guys

DatabaseMigratorClass Error

Luiz Lima — Tue, 09 Mar 2010 11:47:29 GMT

Hi,

I´ve copied and made changes in the SampleDataInstaller program and everything was working ok, but at the end of process I´ve got an error (showed in attachment image).
I think that is related to my FKs???

Any help?

Tks

Changing Filename on Database originally imported into DDT

Charles R Hankey — Sun, 14 Feb 2010 20:33:02 GMT

I imported SQL Database Membership into DDT in a project called PDSM.NET

I changed the database name to PDSM and made a lot of changes to the schema.

This will never be used to maintain the shema of Membership but is entirely for creating a new database PDSM on a server.

I have deleted all the change history. I can deploy the database to the server as PDSM but the logical filename and the MDF are still Membership_Data.mdf.

How do I clean this out once and for all so the MDF file will be PDSM_data.MDF on deployment ?

TIA

Deploy 1 package to multiple databases on same server

Marcel Heitlager — Tue, 02 Feb 2010 12:53:23 GMT

Hi guys,

I'm trying to do the above. I've looked at the sampledatainstaller and DatabaseMigratorClass info. Still have a few questions though.
1. Is it possible to install a database to a filegroup programmatically? IOW supply the value at runtime?
2. How can I select a database to apply a profile script to that's not in the drop down? Is it possible to change that value on the fly as well?
3. If I want to do a Grant EXEC on PPMUserSecurity_Delete to SOMEID in the script for stored procedures, is it possible to pass in the SOMEID value on the fly?

Thanks

MDDeployMain dialog returning OK when clicking Cancel button, why?

Edhy Rijo — Sun, 27 Dec 2009 00:47:15 GMT

Hi Trent,

Implementing the MMDeployMain.vb class I need to know if the status of the database update, I am assuming that the cmdCancel button will return Windows.Forms.DialogResult.Cancel but instead is returning Windows.Forms.DialogResult.OK, why?

Am I missing some other property here that will let me know if the update completed or the user decided to cancel the process?

Thanks!

Versioning pkg Files

Geoff Hirst — Mon, 07 Jul 2008 09:32:48 GMT

Guys,

My application makes use of the superb flexibility of the DDT. What I need to be able to do, is stop users importing 'old' pkg files. Is there a way to do this?

thanks in advance.

Geoff Hirst

DateTime2 support in DDT 1.6.7 beta?

Edhy Rijo — Wed, 22 Apr 2009 11:05:55 GMT

Hi Trent,
I am creating a new table with a field type "DateTime2" and when deploying to SQL2008 I get an error when trying to create the xx_Insert store procedure:

[codesnippet]
X 4/22/2009 11:52:11 AM-> An error occurred while creating the stored procedure [dbo].[Inventory_Insert].
X 4/22/2009 11:52:11 AM-> SqlException
X 4/22/2009 11:52:11 AM-> Operand type clash: datetime2 is incompatible with int
[/codesnippet]

What am I doing wrong?

Trigger Deployment tr_Schema column not found

dgsoft — Mon, 15 Jun 2009 05:22:49 GMT

Hi,
I have a problem with Trigger Deployment. I'v got an error message Column tr?Schema not found in table DBETriggers. I had check this table. column is not there.
I check support messages before and Uninstall StrataFrame and Install it again. It does not help.. the error message in any case appears.

Merging several packages in a single profile?

Michel Levy — Mon, 09 Nov 2009 12:55:30 GMT

Hi,

Let's say 3 development teams (1 at customer's site, and 2 consultants) with no LAN or VPN to join them, only mail or ftp. Each team owns licences for SF and DDT, and can create deployment packages to apply on customer's SQL Servers (and of course on SQL Servers for tests at consultant's office)

When I receive customer's package, I can import it in a profile and deploy it from that profile. From another profile, I generate a package, and customer may deploy this package I'll send him. And of course, each deployment delete and replace what was locally written :angry:

How could I merge the 2 packages into a single, in order to see all modifications in a single profile? from within DDT? with a merge replication in SQL Server? with a versionning product (Visual SourceSafe or another one)?

Thanks in advance for all advice.

Deploying package into many databases resided in the same server

Luiz Lima — Mon, 09 Nov 2009 06:31:41 GMT

Hi guys,

I have a lot of customers using the same server and i´d like to deploy automatically the whole db changes (including profile scripts) to all databases inside the server.
This can be occurs with a new database also.

If I do it using DDT Deploy Button, changing the database name, the system rename the database and create another file with MDF extension.
I know that it´s the a DDT concept, but i´d like to know how can I do that automatically without rename.

See the attached images.

Tks

Luiz

How to define an SQL Server function withing DDT?

Edhy Rijo — Sun, 01 Nov 2009 22:13:00 GMT

I have a SQL Server function which I have not problem creating it in SQL Server Manager Studio, but when try to create it in the DDT I always get an error when try to deploy the UDF.

Here the code I have in the DDT, also look at the udfSample.png image:
[codesnippet]
(@FK_Customers INT)
RETURNS varchar(20)

AS
BEGIN
DECLARE @ParkingNumbers varchar(20)
DECLARE @IsInactive BIT

SET @ParkingNumbers = ''
SET @IsInactive = 0

SELECT @ParkingNumbers = @ParkingNumbers + LTRIM(cast(v.ParkingNumber as varchar(3))) + ','
FROM
dbo.Vehicles V
WHERE
(V.FK_Customers = @FK_Customers AND
V.IsInactive = @IsInactive)
ORDER BY
v.ParkingNumber

RETURN @ParkingNumbers
END
[/codesnippet]

Here is the code I use in Manager Studio with not problem:
[codesnippet]
CREATE FUNCTION dbo.udf_GetParkingNumbers (@FK_Customers INT)
RETURNS varchar(20)

AS
BEGIN
DECLARE @ParkingNumbers varchar(20)
DECLARE @IsInactive BIT

SET @ParkingNumbers = ''
SET @IsInactive = 0

SELECT @ParkingNumbers = @ParkingNumbers + LTRIM(cast(v.ParkingNumber as varchar(3))) + ','
FROM
dbo.Vehicles V
WHERE
(V.FK_Customers = @FK_Customers AND
V.IsInactive = @IsInactive)
ORDER BY
v.ParkingNumber

-- SELECT @ParkingNumbers

RETURN @ParkingNumbers

END
GO
[/codesnippet]

The error I get from DDT when try to deploy the UDF is:
[codesnippet]
X 11/1/2009 11:09:09 PM-> An error occurred while creating the stored procedure [dbo].[spGetParkingNumbers].
X 11/1/2009 11:09:09 PM-> SqlException
X 11/1/2009 11:09:09 PM-> Incorrect syntax near the keyword 'DECLARE'.
X 11/1/2009 11:09:09 PM-> Incorrect syntax near the keyword 'AS'.
X 11/1/2009 11:09:09 PM-> Must declare the scalar variable "@ParkingNumbers".
X 11/1/2009 11:09:09 PM-> Must declare the scalar variable "@ParkingNumbers".
X 11/1/2009 11:09:09 PM->
X 11/1/2009 11:09:09 PM-> Source : .Net SqlClient Data Provider
X 11/1/2009 11:09:09 PM->
X 11/1/2009 11:09:09 PM-> Stack Trace:
X 11/1/2009 11:09:09 PM-> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
X 11/1/2009 11:09:09 PM-> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
X 11/1/2009 11:09:09 PM-> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
X 11/1/2009 11:09:09 PM-> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
X 11/1/2009 11:09:09 PM-> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
X 11/1/2009 11:09:09 PM-> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
X 11/1/2009 11:09:09 PM-> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
X 11/1/2009 11:09:09 PM-> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeploySprocsOfPriority(Database parent, DatabaseInfo dbInfo, Int32 priority)

[/codesnippet]

What am I doing wrong in DDT to get this error, while the same code works just fine in Manager Studio?

computed column, how to do?

Michel Levy — Sun, 25 Oct 2009 12:03:45 GMT

Hi,

I need a computed column in a SQL server table. Is it possible to define it from within DDT?
When I create it in SQLServer Management Studio, and import the database in DDT, I can't see that it is a computed column.

Controlling column order

Keith Chisarik — Mon, 05 Oct 2009 07:47:37 GMT

How does one control the column order when maintaining fields in the DDT? Ideally the column order that ends up in SQL should match the order displayed in the DDT. It does not, additionally I have an occurrance where the column order is different when deployed to two different SQL servers even after the tables on both servers have been dropped. This is wreaking havoc with some import functions I have.

SQL 2000 and 2005 support

ChanKK — Tue, 06 Oct 2009 09:17:57 GMT

Hi,
I would like to support SQL 2000 and 2005. How could I do it without creating 2 projects?

Beside, I found some of the fields used by SF such as localization are using VARCHAR(max) which is not supported in SQL 2000. How to handle this?

Thank you

Develop on SQL Server but Deploy to SQL Server Express

Russell Scott Brown — Wed, 02 Sep 2009 22:21:24 GMT

Do most people develop their applications on SQL Server even though they will deploy to SQL Express? I'm using SQL Express because the final application will run on SQL Express on client notebooks and so this will force me to be very familiar with what the express version can and cannot do.

I would like to do everything on SQL Server but I was wondering if there were any "gotchas" I should be aware of. Is this what most people do?

Thanks

Setting Collation for a New Database Install

Geoff Hirst — Sun, 10 May 2009 09:41:19 GMT

Chaps,

Can I set the collation for a new database anywhere? If not, could this be added?

In the meantime, can I work around it by using a pre-deployment script?

thanks in advance

Geoff

Localization and Messaging Editor Search

Derek Price — Mon, 27 Apr 2009 13:05:14 GMT

I must be missing something here, but when using the Localization and Messaging Editor, how do I search for a value or key? In Visual Studio in the Forms Designer, it's possible to right-click on a control and get the search key or value functionality. Where is this in the actual Localization Editor?

Thanks,
Derek

Does the DDT work with an oracle database ?

Kenneth Langley — Thu, 13 Aug 2009 07:10:15 GMT

Does the DDT work with Oracle Server and are there any gotcha's in using Oracle Databases.

View Fields not showing in DDT

Edhy Rijo — Wed, 05 Aug 2009 10:12:20 GMT

I created a view in DDT and for some reason, no fields are being showed in the DDT listview (see DDT-View.png), also noticed that when clicking the "Show Fields" button while editing the view, no fields are also listed (see ViewProperties - Show Fields.png".

This is working fine with SF view "SFSUserPermissionInfo". Despite this issue, my view was deployed just fine and it is also working fine.

What may be happening here?

Data Deployment Package file problem

Alan Jones — Tue, 28 Jul 2009 09:04:05 GMT

Hey guys,
I've ran into an issue deploying package files from a dvd. The meta-data phase works smoothly, but then errors when attempting to deploy the actual data. The error message is 'Access to path D:\mypackage.pkg' is denied.

I was able to get around this by changing the code in DbEngine -> DatabaseMigrator -> EnumDeploymentPackages where it was attempting to open it with FileAccess.ReadWrite (the default for a new PackageFile).

from:
Dim loPackage As New PackageFile(MetaDataPkgPathAndFileName, True, False, PkgPassword)

to this:
Dim lopackage As New PackageFile()
lopackage.FileOpenAccess = FileAccess.Read
lopackage.Open(MetaDataPkgPathAndFileName, True, False, PkgPassword)

Any chance of including this in your next update/release?

Move file to another file group?

ChanKK — Wed, 24 Jun 2009 12:15:17 GMT

Hi,
May I know how could I configure DDT so that it will move my table to another file group?

Thank you

Data Deployment

dgsoft — Thu, 18 Jun 2009 05:50:59 GMT

Hi,
I have all problems with data deployment which described there http://forum.strataframe.net/FindPost16721.aspx
All...
Ok.. if DbNull exception.. I can fix manually record by record change null to some value in my example data.. but I can't do nothing with TIMESTAMP exception..
Is there way or trick to exclude timestamp from the data deployment process?
I need to install example data on the customer side.. and can't do this..
Maybe exist another tool to deploy data to SQL Server.. (but there is keys and relations.. :(( ) any help please...

TEXT / NTEXT data type

ChanKK — Wed, 10 Jun 2009 03:01:23 GMT

Hi,
I found that DDT doesn't support NTEXT/TEXT data type. May I know why?
I know that it is not recommended to use these data type, however, I really need it as I need to store some process log which would exceed 8K size. Having char field and referring physical path is not preferable in our case.

It is possible to modify the XML generated but it would cause mistake in future.

Please advice. Thank you

How to: Automating DDT updates for customers

Edhy Rijo — Mon, 08 Jun 2009 09:56:59 GMT

Hi guys,

I know that we can use DDT packages with the DatabaseMigrator Class, but I have the following concerns:

[quote]How to control versioning of the package to be installed at the customer's database? in other words, how my update process will know that a particular database needs to be updated?[/quote]

[quote]Also how to check from my application that the database is properly updated to the required version?[/quote]

I am guessing that I would need some sort of version table in my database to hold the database version and check on that field value to update the database or refused my application to run if the database is not withing the required version. Does this make sense? how are other managing this stuff?

Thanks!

Problems with creating Relationship

Ulrik Mueller — Wed, 22 Apr 2009 03:33:07 GMT

In my current startup project on StrataFrame - i'm trying out with something very simple, but i'm getting stuck on creating a foreign key relationship between two tables.

I keep getting "There is no primary or candidate keys in the referenced table 'customer' that match the referencing column list in the forwign key 'fk_co_zip'"

BO1: Customer - cu_number (PK), cu_name, cu_zip_number

BO2: Zipcodes - zip_number (PK), zip_text

I'm trying to make a foreign key between cu_zip and zip_number.

I'm running on MS SQL 2005 Express Edition.

Hope that some of you can come up with the gold answer (i'm sure it is stragiht forward and simple)

Best regards

Ulrik Müller

Error converting DateTime field to DateTime2 in SQL2008 with DDT

Edhy Rijo — Mon, 13 Apr 2009 13:10:41 GMT

Hi Trent,
Today I upgraded my dev computer to SQL2008, I want to take advantage of the new DateTime2 and Date fields in SQL2008, after changing one of table in the DDT to use DateTime2 and deploying the package I got the following error:
[quote]
X 4/13/2009 1:50:05 PM -> Altering table 'Inventory' failed.
X 4/13/2009 1:50:05 PM -> FailedOperationException
X 4/13/2009 1:50:05 PM -> Alter failed for Table 'dbo.Inventory'.
X 4/13/2009 1:50:05 PM -> ExecutionFailureException
X 4/13/2009 1:50:05 PM -> An exception occurred while executing a Transact-SQL statement or batch.
X 4/13/2009 1:50:05 PM -> SqlException
X 4/13/2009 1:50:05 PM -> Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.
X 4/13/2009 1:50:05 PM ->
X 4/13/2009 1:50:05 PM -> Source : Microsoft.SqlServer.Smo
[/quote]

Shouldn't the DDT take care of running whatever command is required to do this type of conversions? or this must be handle via the Pre/Post script?

Unique Index Problem

Aaron Young — Thu, 04 Sep 2008 10:03:40 GMT

Hi,

I have a ROWGUID field and index in every table in a SQL Server 2005 database. The indexes are unique and non-clustered and all indexes and fields are called the same - ROWGUID. This database is pre-StrataFrame so I am trying to setup the model in DDT to match it.

After I set the Unique property on the ROWGUID indexes (see attached screenshot), when I try and deploy a new database, it will only create the index on the first table and for all other tables the DDT reports the error:-

"There is already an object named 'ROWGUID' in the database. Could not create constraint."

When the Unique property is set, it looks like the DDT wants the indexes to be called different names. When the Unique property is reset it will create the indexes albeit as non-unique.

SQL Server doesn't need a Unique index to have a unique name so I was wondering if I have missed something?

Aaron

Unique Index modification

Edhy Rijo — Wed, 01 Apr 2009 16:07:43 GMT

I have a table with a unique index, I wanted to remove the "Unique" using the DDT and got the following error:
[quote]Modifying the IsUnique property of the Index object is not allowed. You must drop and recreate the object with the desired property.[/quote]
Does this mean that I would need to connect to the customer's server, modify the table and remove the unique flag? or is there a wait to automate this in the DDT?

Error loading server in DDT Deployment Data Package

Edhy Rijo — Fri, 03 Apr 2009 12:37:20 GMT

When creating a data package clicking in the command button to locate the server I get the following error:

[quote]
ArgumentOutOfRangeException
InvalidArgument=Value of '0' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex

Source : System.Windows.Forms

Stack Trace:
at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
at MicroFour.StrataFrame.Data.BrowseSQLServers.LoadSQLServers()
at MicroFour.StrataFrame.Data.BrowseSQLServers.bwLoadServers_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)
[/quote]
Of course no server is found. I am using the latest beta 1.6.6.7. MS-SQL Server 2005

Data Deployment Problem

Aaron Young — Thu, 26 Mar 2009 18:50:30 GMT

Hi,

Just noticed a problem with decimals during data deployment. I have a simple VERSION table defined as follows:-

Field Name Field Type
NAME VarChar(40) - primary key
VALUE Decimal(10,2)

I have created a data deployment package set to overwrite and have noticed that the deployment stored procedure which is created doesn't support decimal places in the VALUE field. The stored procedure definition is:-

CREATE PROCEDURE VERSIONInsertOverwrite @NAME as VarChar(40), @VALUE as Decimal AS BEGIN DELETE FROM VERSION WHERE NAME = @NAME INSERT INTO VERSION (NAME, VALUE) VALUES (@NAME, @VALUE) END

When the procedure is executed as follows, it drops the decimal places:-

exec VERSIONInsertOverwrite @NAME='Database',@VALUE=10.01

The above code stores a value of 10 instead of 10.01

Just to confirm, the VALUE field is definitely defined as 10.2 and can store a value of 10.01 through an update statement.

Aaron

Field Constraint errors

Jason Seidell — Fri, 13 Feb 2009 15:03:01 GMT

This is getting frustrating and I hope there is a solution, or maybe this is a new bug???

From the best of my understanding this is what is happening.

1) Originally built and deployed a set of databases with version 1.6.0, did not add any NOT NULL or default value constraints on fields.

2) Some time later, we updated to version 1.6.5. Started having occasional exceptions when accessing BOs with a field with a NULL value. So we started updating fields whenever we needed to redeploy the DDT to turn on the NOT NULL option and set default values.

2.1 - When adding these we keep getting DDT errors stating, 'Error, cannot add constraint, 'Fieldname' already exists. This error is because we have multiple tables with the same fieldnames and the constraints get added with only the fieldname. However, if we deploy the exact same package to a fresh install the errors don't duplicate because it names the constraints 'DF_tableName_fieldName'. The only recourse is to deploy, change constraint names, redeploy, change additional set of constraint names, and repeat until it finally adds all the constraints (because after it fails adding the first constraint it stops adding constraints to that table). So this process can easily take 6-12 times to finally get a clean deploy. I have tried deleting all the constraints from the database and then redeploy but they just get assigned the same name and still creates the errors.

So I'm totally lost as to what is happening, how to best fix this, and how to keep it from happening again.

:( Jason

dep shut it down

Kevin Swanzey — Fri, 06 Mar 2009 06:13:53 GMT

I am trying to convert tables from a vfp database and I get a message stating dep has closed the program.

this is in the event viewer:

Faulting application DatabaseDTK.exe, version 1.6.6.0, time stamp 0x48ceb31d, faulting module unknown, version 0.0.0.0, time stamp 0x00000000, exception code 0xc0000005, fault offset 0x0bdb0f06, process id 0x9f0, application start time 0x01c99e53eed9a80c.

Help.

How to change field data type?

ChanKK — Wed, 04 Mar 2009 05:59:27 GMT

Hi,
I have a field which data type is wrongly defined. I would like to change it. However, SQL Server unable to convert it and complaint unable to convert type X to type Y even though that is no data on it (but got records) via DDT.

As I know, we can use copy method as workaround - Create new table, APPEND back data to new table, drop old table and rename new table with old table name. But how to do it using DDT?

Thank you

DDT deploy PKG build using 1.6.7

Keith Chisarik — Tue, 03 Mar 2009 13:54:15 GMT

So I am running 1.6.7 and I need to make a structure change in the field to a 1.6.5 installtion, will I need to install the v.10 SMO assemblies for the new .pkg file to deploy to an existing SQL 2005 server?

Also, I just realized that I will have to recompile my BO's as well, what SF assemblies have to be updated in the field to support this change? Or should I just update them all in your opinion to keep them in sync?

Problem in deploying data with DDT

GRocchi — Fri, 06 Feb 2009 09:07:06 GMT

I have a project and a table which I'd like to get deployed by the DDT.

If I run the DDT and the target table is empty in the database I get 74 records (that's correct)
If instead the table has records in it (the 74 I just exported) the DDT says he has imported 74 records, but when I see the table actually only 20 exist.

The Deployment data package is configured with the Overwrite option (I expect to rewrite the whole table every time) and the table has a primary key made by two column (this last thing is perhaps the only difference between other tables that are working well)

What can the problem be?

How to change the data file location?

Chan — Mon, 16 Feb 2009 21:08:47 GMT

Hi,
How do I allow user to choose the database destination location to be created using DDT, during deployment at customer site?

Thank you

Lock DDT?

Derek Price — Thu, 12 Feb 2009 13:02:35 GMT

We are using StrataFrame in a team environment and occasionally have had issues with multiple people accessing the DDT at the same time. Is there any locking or read-only feature available? If not, any ideas?

Thanks,
Derek

problem to deploy trigger in Deployment Toolkit

Raymond Lo — Thu, 12 Feb 2009 08:30:18 GMT

Hi,

I have a problem to deploy a triger in DDT, my trigger code as bellow:

====================================

AFTER INSERT
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON

AS
BEGIN

-- Prevent the result count from interfering
SET NOCOUNT ON;

-- Add trigger logic here
declare @curid int, @curcode nchar(5), @cureffectivedate smalldatetime, @currate smallmoney, @lastuser nvarchar(25)
select @curid=curid, @curcode=curcode, @cureffectivedate=cureffectivedate, @currate=currate, @lastuser=lastuser from inserted
insert into exchangerate values (@curcode, @curid, @cureffectivedate, @currate, @lastuser, getdate())
END
=============

too simple but I don't know why can not to delpoy it, the error message as bellow.

Source Control and DDT

Chan — Sat, 07 Feb 2009 19:27:59 GMT

Hi,
Shall you share experience on how to keep track changes done in DDT during development? Would you check in package generated to source control system? How do you compare the the difference?

Thank you

Database name (local/remote)

Chan — Sun, 21 Dec 2008 21:16:30 GMT

Hi,
I have questions as below:

1. How could I allow user to decide database name during DDT deployment?
2. I have some view that join tables from local and remote database. The remote database name could be vary among customer even though it is has the same structure. How could I tell DDT at runtime so that it will "change" my view defination to map to the remote database?

Please advice.

Thank you