JWColby
jwcolby at colbyconsulting.com
Fri Nov 3 16:09:30 CST 2006
Whoa, cool. Now you da man! See how easy it is to be da man? Boy am I out of my league here. 8( Now I just gotta try it. If I can do this, then I can actually use that other server machine I built for something useful. Next YouDaMan prize goes to the one who provides the syntax to transfer an entire table - structure, data and indexes intact, from one db to another. That ought to slow you folks down! John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Doris Manning Sent: Friday, November 03, 2006 4:18 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Any gut feelings? John, Yes, it is possible. Same server instance...Database.dbo.Table.Field Separate server instance... Server.Database.dbo.Table.Field Doris Manning Hargrove Inc. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Friday, November 03, 2006 3:55 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Any gut feelings? So question: Is it possible to spread tables out across databases and use queries that join tables in other databases (inside the same SQL Server instance)? The reason I ask is that I have all of these raw data tables, which I need, need to keep around, but don't need active. It would be handy (for size of database files reasons) to have the raw source tables out in their own database and the finished processed, indexed tables in another table. Getting the raw data into the finished data table is the issue. Exporting 65 million records, even a few fields, to a csv file or the like is not exactly dba friendly. John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com