Unanswered: Copy Table Data From One Db To Another
I have a SQL Server db serving as a data warehouse. At given points in time, I need to copy ALL of the data from this db into another db on the same server. The second db has an identical structure, number of tables, and naming convention as the first. No key fields or relationships need to be taken into consideration. Given I am using VB and SQL Server 2000, what are my most efficient options? There is also the need to do this process from a SQL Server db to an Access db if anyone has a tip on that. Thanks in advance for the support!!