No announcements
Found 2281574 threads
-
0 Votesmoving data between tables with constraints
to the constraints between the tables in the database. Ideally, I would like to move the items to a table called “Archive”, for example. This way I will still ...Answered | 2 Replies | 1756 Views | Created by Jonsey - Thursday, January 26, 2012 7:34 AM | Last reply by Jonsey - Thursday, January 26, 2012 2:44 PM
-
0 Votes
SSIS: copy data to tables with: Constraints
package was created with no constraints on the order in which the tables would get transferred - it's attempting to do as many in parallel as it can. It's pretty easy ...Unanswered | 3 Replies | 4703 Views | Created by edm2 - Thursday, May 21, 2009 10:48 PM | Last reply by Todd McDermid - Friday, May 22, 2009 6:52 PM -
0 Votes
Merging Tables and Data Constraints
I am trying to merge two data tables with similar schema. I have had success with doing this, but all too often I get a very frustrating "Failed to enable ...Answered | 2 Replies | 2754 Views | Created by A.Russell - Wednesday, December 19, 2012 3:39 PM | Last reply by Sambath Raj.C - Friday, December 21, 2012 9:59 AM -
0 Votes
create tables with constraints
http://msdn2.microsoft.com/en-us/library/ms172971.aspx Another option would be to use Merge replication, which replicates all constraints (including ...Answered | 1 Replies | 6116 Views | Created by SharePointGuy123 - Thursday, April 19, 2007 1:00 PM | Last reply by ErikEJ - Friday, April 20, 2007 8:18 AM -
0 Votes
Moving Data between Databases
new server is SQL 2008. We are moving data between the old database and new database as the upgraded app cannot directly use the old ...Answered | 1 Replies | 7591 Views | Created by pczerniak - Friday, May 8, 2009 8:06 PM | Last reply by Sankar Reddy - Friday, May 8, 2009 8:39 PM -
0 Votes
transferred tables without constraints
Generate Script Wizard to transfer tables with constraints.Answered | 1 Replies | 4979 Views | Created by MeetP - Tuesday, June 22, 2010 5:36 PM | Last reply by Alberto Morillo - Tuesday, June 22, 2010 7:22 PM -
0 Votes
Moving rows between repeating tables
HI David , I got the same situation here. I want to copy the repeating table row values into another tables. So, Can you provide more ...Unanswered | 2 Replies | 7880 Views | Created by David Lozzi - Wednesday, July 30, 2008 3:04 PM | Last reply by Venkat kommisetty - Monday, January 17, 2011 4:56 AM -
0 Votes
Relationship between data tables
. & ...Answered | 2 Replies | 3150 Views | Created by TaubertRC - Thursday, May 21, 2009 6:39 PM | Last reply by Cor Ligthert - Tuesday, May 26, 2009 8:24 AM -
1 Votes
Copy tables with all constraints
/transactsql/thread/17a16dc4-dcf1-4de8-baba-6949c55a4c5d Also you can consider using Transfer SQL Server Objects task with SSISAnswered | 4 Replies | 40411 Views | Created by Khan_K - Friday, May 14, 2010 8:27 PM | Last reply by Sorna Kumar Muthuraj - Monday, May 17, 2010 3:00 PM -
0 Votes
Moving data between different servers
Query to move data between tables on different servers? example: Server: Server1, Database: Database1, Schema: dbo, Table: ...Answered | 5 Replies | 4256 Views | Created by CSharp Enthusiast - Tuesday, March 30, 2010 11:34 PM | Last reply by pradeepz_reddy - Wednesday, March 31, 2010 12:50 AM -
0 Votes
Moving data between tables in Azure SQL Database
can sync two table data with different table name and different columns using Sync Framework. But if you get the source data by join multiple ...Unanswered | 4 Replies | 1552 Views | Created by MSBI Dev 2012 - Monday, May 12, 2014 1:12 PM | Last reply by MSBI Dev 2012 - Thursday, May 15, 2014 8:16 AM -
0 Votes
Disabling all constraints on tables
again -- The possibility exists that data prevents a constraint to become trusted ALTER TABLE <TableName> WITH CHECK CHECK CONSTRAINT ALL; GO -- Proof ...Answered | 5 Replies | 2355 Views | Created by warnerrj79 - Friday, December 7, 2012 3:05 PM | Last reply by Chris Sijtsma - Friday, December 7, 2012 7:20 PM -
1 Votes
inserting into tables with crazy constraints ?
to insert into one table and have it insert into all the reference and constraints bypassing the need to write large code to put in test data for tables that have ...Answered | 3 Replies | 1346 Views | Created by displaynameformyprofile - Monday, November 19, 2012 9:28 PM | Last reply by Kent Waldrop - Tuesday, November 20, 2012 5:15 PM -
0 Votes
MOVING DATA BETWEEN SERVERS
Well, if you're simply moving the data from the results table to the truncated table, for best performance I'd simply drop the truncated table your talking about, then have the DTS ...Unanswered | 2 Replies | 7214 Views | Created by Lalewicz - Friday, April 21, 2006 7:01 PM | Last reply by Chad Boyd MSFT - Sunday, April 23, 2006 8:55 PM -
0 Votes
Table Partition (with foreign key constraints on source tables)
foreign key relationships in the source tables after switching the partition. Is there any other approach for switching partitions with foreign key ... -
0 Votes
Copy data between tables
one, just adding Google's extra columns. As it is, I can create a .NET app and copy the data through a SELECT and then an INSERT to the proper tables ...Answered | 2 Replies | 1348 Views | Created by Fernando A. Gómez - Thursday, October 4, 2012 8:32 PM | Last reply by Dummy yoyo - Friday, October 5, 2012 4:44 AM -
1 Votes
Moving TONS of data between tables Advice Needed
Can you batch up your inserts? ~50K at a time until they're all done and dusted. This would require a loop and the source data to have a key. Alternatively, and I ...Unanswered | 2 Replies | 3140 Views | Created by Fanbladeus - Friday, March 20, 2009 12:04 PM | Last reply by richbrownesq - Friday, March 20, 2009 4:16 PM -
0 Votes
Moving data between fields
the historical information from the first field into the WorkItemsLongText table with the associated work item ID's and the field id. The script functioned properly and the data was ...Answered | 1 Replies | 3695 Views | Created by pfontyn - Wednesday, September 19, 2007 2:47 PM | Last reply by Tiago Pascoal - Wednesday, September 19, 2007 4:19 PM -
1 Votes
Data Feed Between Tables
Hi Everyone, I have two tables. Source table and destination table have same columns. (for example A and B) I want to transfer data from A to B. ...Answered | 2 Replies | 5031 Views | Created by sqlserver2000Queries - Saturday, April 17, 2010 5:26 PM | Last reply by sqlserver2000Queries - Sunday, April 18, 2010 12:39 AM -
0 Votes
Moving database with encrypted data between servers
We have a sql 2008 dev database with tables encrypted by a passphrase and symmetric key. We need ot copy that database to a staging server. Is there an article ...Answered | 7 Replies | 11415 Views | Created by edm2 - Friday, November 13, 2009 5:47 PM | Last reply by waqasmcs - Tuesday, December 17, 2013 7:36 AM - Items 1 to 20 of 2281574 Next ›
No announcements
