Posts
Sort by recent activity
Failed to snapshot
Hi
I am using ANTS memory profiler to profile my ASP.NET web app. However, I hit this error when I take snapshot. I am running under Windows 7 64 bits machine, however my web app pool is set "Enabl...
Work using SDC UI but not command line
Hi,
I have create SDC project and it works under SDC UI. However, I hit error if I run it using command line
SQLDataCompare /project:c:\myproject.sdc /ignoremissing /scriptfile:c:\abc.sql
Error: Co...
INERT statement
Hi,
SQL Prompt auto list out INSERT code template after I key in INSERT INTO mytable. Anyway to:
1. Allow me to select what fields to be inserted, or all?
2. Allow navigation to each value portion?...
Parameter navigation
Hi,
I tried SQL Prompt and found that it doesn't support "parameter navigation". For example, when I type "EXEC ", it prompted stored proc list for selection. After I select SP, it will parameter ...
How to control table sync order
Hi,
I hit error when sync one of my table. It is caused by the Table PK used in another table. I am using trigger to control RI instead of foreign constraint.
Due to this, I need to control the tab...
Sync data programmatically
Hi,
I have defined data sync using sql data compare and save it in project file. I would like to sync data programmatically, with all my configuration saved in project file with only few changes:-
...
Curcular dependency
Hi,
When I compare database, I have warning as below. What does it meant?
Severity: High
Title: Circular dependency for the table or view [dbo].[ItemSizes]
Thank you
Evaluation question
Hi,
I have few questions as below.
1. I have master and child tables, Sales and LineItems. When I sync sale txns from retail shop to HQ, i would need to filter using column TerminalID.
This field i...