Activity overview
Latest activity by ewancampbell69
Afternoon !
Hope you're well.
Looking to SQL Data Compare 2 databases that are on the same server.
My question is - is the data compare job gong to generate another copy of the DB on this server ( ie. 3 DBs in total ) to do the compare, or will it just use the 2 existing DBs ?
thanks
Ewan / comments
Afternoon !
Hope you're well.
Looking to SQL Data Compare 2 databases that are on the same server.
My question is - is the data compare job gong to generate another copy of the DB on this server ( ...
Afternoon Rob
Thanks for the reply.
Very pleased with the products - we use the toolkit a lot.
Excellent for most of our DB synch tasks here.
Just wondering how feasible it will be to use Data Compare when our DB gets to terabytes of data. ( pretty soon )
I'm trying to avoid copying huge amounts of data across the network.
Was hoping to use Data Compare to only transfer rows that have changed across from server A to server B.
So no way to compare across say linked servers ?
May be possible for us to link both servers into the same SAN - have you had any experience of this setup ?
Thanks
Ewan / comments
Afternoon Rob
Thanks for the reply.
Very pleased with the products - we use the toolkit a lot.
Excellent for most of our DB synch tasks here.
Just wondering how feasible it will be to use Data Comp...
Thanks for the prompt replies guys !
Dont think the SQL server spec is an issue
Connected to SAN storage, with 8 CPUs and 32GB RAM.
Makes sense about the data transfer.
I was wondering was there a way to do the compare without transferring the whole DB across to server B first ?
Good idea - I'll experiment with the /ignoreidentical command line switch.
Timestamp idea is also good, i'm sure we have one.
The WHERE clause - wont be feasible really i dont think in production - the DB I want to use this on has over 300 tables.
Yes - we use PK clustered index columns to do the compare.
Thanks again
Ewan / comments
Thanks for the prompt replies guys !
Dont think the SQL server spec is an issue
Connected to SAN storage, with 8 CPUs and 32GB RAM.
Makes sense about the data transfer.
I was wondering was there a ...
Data Compare
Good day to you - I hope you can help.
Using SQL Data Compare version 6.1.1.308 Pro
Command Line job to update a database on server B from the same database on server A. (identical schemas)
PROBLE...