Information générale
Catégorie:
Code, syntaxe and commandes
Titre:
Making a copy of a SQL Server Table
Hi
In my app, at month end I need to take a copy of a few Tables, which will be refrred to occasionlly subsequently. I am wondering whats the best way of doing this in SqlServer . I do need to keep a copy of these at a pint in time, but dont particulalrly want to bloat the Database with them.
The tables typically could be 1.6 Gigs to 2 Gigs
In VFP, I used to just take a copy of the Table (as a free Table outside the database) and append the date to it (so it would be called something like MyTable_27_02_2012). This way, its kept outside the DBC, but I can refer to it easily if i need to.
I have seen a BulkCopyToXml, but am concerned that , because XML causes a lot of bloat, the XML file will end up to be very large. Are there any other options worth considering ?
Tia
Gerard
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement