Esempio n. 1
0
        public void Generate(Package sourcePackage, Package targetPackage, FileInfo outputFile)
        {
            var serializer = new XmlSerializer(typeof(DataSchemaModel));
            var uri        = PackUriHelper.CreatePartUri(new Uri("/replication.xml", UriKind.Relative));

            var sourceModel = (DataSchemaModel)serializer.Deserialize(sourcePackage.GetPart(uri).GetStream());
            var targetModel = (DataSchemaModel)serializer.Deserialize(targetPackage.GetPart(uri).GetStream());

            var outputFileSql = new List <string>();

            foreach (var publicationToCreate in sourceModel.Model.Elements.Except(targetModel.Model.Elements, x => x.Name))
            {
                var createPublicationStep = new CreatePublicationStep(publicationToCreate);
                outputFileSql.AddRange(createPublicationStep.GenerateTSQL());
            }

            foreach (var publicationToAlter in sourceModel.Model.Elements.Intersect(targetModel.Model.Elements, x => x.Name))
            {
                var sqlPublicationComparer      = new SqlPublicationComparer();
                var matchingPublicationInTarget = targetModel.Model.Elements.Single(x => x.Name == publicationToAlter.Name);

                var alterPublicationStep = new AlterPublicationStep(sqlPublicationComparer.Compare(publicationToAlter, matchingPublicationInTarget));
                outputFileSql.AddRange(alterPublicationStep.GenerateTSQL());
            }

            foreach (var publicationToDrop in targetModel.Model.Elements.Except(sourceModel.Model.Elements, x => x.Name))
            {
                var dropPublicationStep = new DropPublicationStep(publicationToDrop);
                outputFileSql.AddRange(dropPublicationStep.GenerateTSQL());
            }
        }
        public void Execute()
        {
            var outputSerializer = new XmlSerializer(typeof(DataSchemaModel));
            var model            = (DataSchemaModel)outputSerializer.Deserialize(new FileStream(@"Samples\Extracted Model.xml", FileMode.Open));

            var step = new CreatePublicationStep(model.Model.Elements[0]);
            var sql  = step.GenerateTSQL();

            foreach (var line in sql)
            {
                Console.WriteLine(line);
            }
        }
        public void RecreateExistingPublication()
        {
            using (var connection = new SqlConnection(@""))
            {
                connection.Open();

                var extractor = new SqlPublicationExtractor();
                var model     = extractor.Extract(connection);

                var step = new CreatePublicationStep(model.Model.Elements[0]);
                var sql  = step.GenerateTSQL();

                foreach (var line in sql)
                {
                    Console.WriteLine(line);
                }
            }
        }