Log in

Copia di una tabella da un altro database MSSQL

By cillo at April 07, 2009 01:47
Filed Under: Microsoft, SQL

Talvolta mi capita di dover copiare tabelle da un database SQL ad un altro; per copiare sia lo schema che i dati normalmente utilizzo questa query:

SELECT * INTO NomeDbDestinazione.dbo.NomeTabellaDestinazione FROM NomeDbOrigine.dbo.NomeTabellaOrigine

Lo strumento Microsoft SQL Server Database Publishing Wizard 1.1 permette di salvare un unico script che può essere utilizzato per ricreare un database, e anche questo è decisamente molto comodo.

Tags: ,
Comments (0) E-mail Kick it! DZone it! del.icio.us Permalink Post RSS
Comments are closed

About Me

My work experience began in the second half of the nineties, designing and developing mainly internet-based solutions for businesses.
As a natural evolution, I started focusing on the architectural aspect of IT systems.
I have been a system administrator and IT manager for years now, and I take care of designing, implementing and maintaining customer IT infrastructures.

If you want to know more, please take a look on

Recent comments

Comment RSS

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in  anyway.

© Copyright 2008