Posts
Sort by recent activity
Copy from one database to another and change schema
I have two databases
db1
db2
I am looking to merge the contents of the two databases. In both both databases, all objects belong to the dbo schema.
What I am looking to do it to move all objects an...
Row Filter of Static Data
I have a table that I want to link Static Data to. However I don't want to link all the rows in this table, I only want to link static data based on a filter.
I am currently using Source Control 2,...
Conflict on identical object schema
Using ver 2.2
I have the following scenaria. I have two tables that are identical, but the column order of the two tables is different
eg.
CREATE TABLE [dbo].[Suppliers](
[Id] [uniqueidentifier] RO...
Backup to multiple files
I have the following scenario.
I am backup up a database to disk, and then with the resulting file I am sending the backup file to amazon's S3 storage.
However, as the backup files are large, I am ...