lucab

Another Subtext Powered Blog
posts - 3, comments - 3, trackbacks - 129

My Links

Archives

Post Categories

SQL Scripter

Chiunque lavori con SQL Server avrà prima o poi avuto l'esigenza di allineare i dati presenti in una tabella con quelli di un'altra. L'esigenza può essere facilmente risolta utilizzando una serie di istruzioni T-SQL in grado di eliminare i record non più necessari, aggiornare eventualmente quelli esistenti ed inserire i nuovi. Nel caso in cui le tabelle da allineare siano parecchie può tornare utile ricorrere a tool di terze parti tra cui il mio preferito è SQL Data Compare prodotto dalla RedGate.

Entrambe queste soluzioni, però, sono attuabili se l'origine e la destinazione sono connessi fra loro. Nel caso in cui si debba procedere a generare degli script per essere eseguiti in un secondo tempo la cosa si complica. L'unico metodo che conoscevo fino a qualche giorno fa era utilizzare questa stored procedure di Narayana Vyas Kondreddi
 
 
le cui funzionalità sono state incapsulate da Andrea Montanari nel suo Dba Manager.
 
Ho scoperto recentemente SQL Scripter, scaricabile liberamente dal link
 
 
che permette non solo la generazione dello script di INSERT dei dati, ma anche l'inserimento condizionato dall'assenza del record, l'aggiornamento dei record modificati o l'eliminazione dei record non più presenti. Decisamente utile, anche in considerazione del fatto che non richiede alcun setup ne lato client e ne, tantomeno, sul server...
 
Bye
 

Print | posted on Monday, August 07, 2006 11:55 AM | Filed Under [ SQL Server ]

Feedback

Gravatar

# cheap phentermine 37.5 mg

Pretty much nothing seems important, but it's not important. Not that it matters. Basically nothing notable going on these days, but whatever. I haven't gotten much done these days. Pfft. So it goes.
6/21/2007 3:14 AM | cheap phentermine 37.5 mg
Gravatar

# xanax bars

My life's been basically boring lately. I guess it doesn't bother me. Not that it matters. I've basically been doing nothing. I've just been letting everything wash over me lately. I can't be bothered with anything recently.
6/22/2007 6:52 PM | xanax bars
Gravatar

# generic viagra canada

I've just been letting everything happen without me recently. So it goes. What can I say? Not much on my mind today. I guess it doesn't bother me.
7/5/2007 1:01 AM | generic viagra canada
Gravatar

# generic ambien cheap

I can't be bothered with anything recently, but I guess it doesn't bother me. I feel like a bunch of nothing. Not much on my mind worth mentioning. I've just been sitting around not getting anything done. I haven't been up to much these days. I just don't have anything to say these days.
7/15/2007 11:55 PM | generic ambien cheap
Gravatar

# lowest cost generic viagra

I haven't gotten much done. Today was a loss. It's not important. That's how it is. Not that it matters.
7/16/2007 4:16 PM | lowest cost generic viagra
Gravatar

# replica watches china

I just don't have anything to say lately, but it's not important. Maybe tomorrow. I've just been hanging out doing nothing. I haven't gotten much done today. I can't be bothered with anything recently.
7/29/2007 11:19 PM | replica watches china
Gravatar

# bmw body kit

I haven't been up to anything these days, but pfft. My mind is like a fog. Not much on my mind. I've basically been doing nothing worth mentioning, but it's not important.
7/31/2007 11:35 AM | bmw body kit
Gravatar

# order cheap tramadol online

I've basically been doing nothing worth mentioning. Whatever. Pfft.
8/5/2007 2:55 AM | order cheap tramadol online
Gravatar

# generic viagra viagrageneric

I can't be bothered with anything these days, but so it goes. My mind is like a void. Shrug. Not much on my mind.
8/8/2007 10:25 PM | generic viagra viagrageneric
Gravatar

# generic online pharmacy viagra

Today was a total loss. Nothing seems worth doing. I haven't been up to much. Shrug. What can I say? I haven't gotten anything done.
8/9/2007 1:15 PM | generic online pharmacy viagra
Gravatar

# buy ambien on line

I haven't been up to much today. That's how it is. Today was a loss. Not that it matters.
8/13/2007 5:10 PM | buy ambien on line
Gravatar

# Crestor.

Denver crestor lawyer. Crestor.
Gravatar

# Rape statistics.

Rape pic. Prince charles rape. Brutal rape. Rape. Fantasy rape.
2/18/2009 6:51 AM | Japanese rape.
Gravatar

# Incest thumbs.

Incest girl. Cartoon incest. Incest grrl. Mother daughter incest. Sex incest. Incest. Incest stories.
2/19/2009 6:40 AM | Incest quest.
Gravatar

# Crestor.

Side effects of crestor. Denver crestor attorney. Crestor cholestral drug. Crestor side effects. Denver crestor lawyer. Colorado crestor attorney. Crestor.
Gravatar

# Taking viagra with cialis.

Side effects of cialis. Cialis best price buy online. Cialis.
2/23/2009 4:31 AM | Cialis.
Gravatar

# Date rape.

Rape scenes. Rape stories. Rape fantasy. Rape. Anime rape.
2/23/2009 9:17 AM | Rape.
Gravatar

# Viagra and cialis.

Cialis.
2/24/2009 5:19 AM | Buy cialis.
Gravatar

# Aunt judy s mature women.

Mature naked women. Adult galleries mature women. Mature women. Mature kingdom. Mature women in stockings.
2/24/2009 11:10 PM | Mature models.
Gravatar

# Xanax norx needed one day fedex overnight delivery.

Half-life of xanax. Xanax.
Gravatar

# Cheapest cialis.

Generic cialis tadalafil mg pills nextag com. Buy cialis. Viagra cialis levitra buy cheap cialis buy ciali. Cialis free sample. Compare cialis and viagra. Cialis.
2/26/2009 6:42 AM | Cialis.

Post Comment

Title  
Name  
Email
Url
Comment   
Please add 7 and 6 and type the answer here:

Powered by:
Powered By Subtext Powered By ASP.NET