Comparing DB's columns and create script

Hi,
I am looking for a solution that can generate a script on column difference
between two databases and its tables.
Basically, I have a one core db and one development db. The development db
has been revised several time and now I need to generate a script that just
adds all new table columns with their defaults to the old core db.
Any knowledge about this or some methods to use.
Thanks in advance
ChristianCheck out SQLCompare, from Red-GAte Software... It will compare the two
databases, and generate a script to do exactly what you need...
http://www.red-gate.com
"Christian Perthen" wrote:

> Hi,
> I am looking for a solution that can generate a script on column differenc
e
> between two databases and its tables.
> Basically, I have a one core db and one development db. The development db
> has been revised several time and now I need to generate a script that jus
t
> adds all new table columns with their defaults to the old core db.
> Any knowledge about this or some methods to use.
> Thanks in advance
> Christian
>
>

Compare data difference between two database in SQLServer 2005

Hi,
I have too databases, their structures are completely same, with minor data
difference, I want to generate a patch SQL statements, not complete backup
by comparing them, thus I can synchronzie the out-dated database with that
script. Does SQLServer2005 provide thus functionality? Or there is other
tool I can use. Thank you
zlf
You can do it yourself if you link the servers, but it may take a good
amount of work. Easier might be to use a third party tool. Red-Gate's SQL
Data Compare is probably the most obvious choice...
http://www.red-gate.com/products/SQL_Data_Compare/index.htm

Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"zlf" <zlfcn@.hotmail.com> wrote in message
news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have too databases, their structures are completely same, with minor
> data difference, I want to generate a patch SQL statements, not complete
> backup by comparing them, thus I can synchronzie the out-dated database
> with that script. Does SQLServer2005 provide thus functionality? Or there
> is other tool I can use. Thank you
> zlf
>
|||On Jun 22, 1:57 pm, "Adam Machanic" <amacha...@.IHATESPAMgmail.com>
wrote:
> You can do it yourself if you link the servers, but it may take a good
> amount of work. Easier might be to use a third party tool. Red-Gate's SQL
> DataCompareis probably the most obvious choice...
> http://www.red-gate.com/products/SQL_Data_Compare/index.htm
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"http://www.apress.com/book/bookDisplay.html?bID=10220
> "zlf" <z...@.hotmail.com> wrote in message
> news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
>
>
> - Show quoted text -
Hi Zif,
another great choice is xSQL Softwares xSQL Data Compare which you can
get from http://www.xsqlsoftware.com - you don't just get 2 weeks of
free trial but you also have it free forever for smaller size
databases (up to a certain number of objects) as well as free with no
limitations for SQL Server Express databases.
Furthermore, we have a well document api (xSQL SDK) that allows you to
integrate the functionality in your own application if you want.
Hope this helps.
Thanks,
JC
xSQL Software
http://www.xsqlsoftware.com
|||It works. Thank both of you
"Adam Machanic" <amachanic@.IHATESPAMgmail.com>
?:%23jF$gbPtHHA.2164@.TK2MSFTNGP02.phx.gbl...
> You can do it yourself if you link the servers, but it may take a good
> amount of work. Easier might be to use a third party tool. Red-Gate's
> SQL Data Compare is probably the most obvious choice...
> http://www.red-gate.com/products/SQL_Data_Compare/index.htm
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "zlf" <zlfcn@.hotmail.com> wrote in message
> news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
>

Compare data difference between two database in SQLServer 2005

Hi,
I have too databases, their structures are completely same, with minor data
difference, I want to generate a patch SQL statements, not complete backup
by comparing them, thus I can synchronzie the out-dated database with that
script. Does SQLServer2005 provide thus functionality? Or there is other
tool I can use. Thank you
zlfYou can do it yourself if you link the servers, but it may take a good
amount of work. Easier might be to use a third party tool. Red-Gate's SQL
Data Compare is probably the most obvious choice...
http://www.red-gate.com/products/SQ...mpare/index.htm
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"zlf" <zlfcn@.hotmail.com> wrote in message
news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have too databases, their structures are completely same, with minor
> data difference, I want to generate a patch SQL statements, not complete
> backup by comparing them, thus I can synchronzie the out-dated database
> with that script. Does SQLServer2005 provide thus functionality? Or there
> is other tool I can use. Thank you
> zlf
>|||On Jun 22, 1:57 pm, "Adam Machanic" <amacha...@.IHATESPAMgmail.com>
wrote:
> You can do it yourself if you link the servers, but it may take a good
> amount of work. Easier might be to use a third party tool. Red-Gate's SQ
L
> DataCompareis probably the most obvious choice...
> http://www.red-gate.com/products/SQ...mpare/index.htm
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"http://www.apress.com/book/boo
kDisplay.html?bID=10220
> "zlf" <z...@.hotmail.com> wrote in message
> news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
>
>
>
> - Show quoted text -
Hi Zif,
another great choice is xSQL Softwares xSQL Data Compare which you can
get from http://www.xsqlsoftware.com - you don't just get 2 weeks of
free trial but you also have it free forever for smaller size
databases (up to a certain number of objects) as well as free with no
limitations for SQL Server Express databases.
Furthermore, we have a well document api (xSQL SDK) that allows you to
integrate the functionality in your own application if you want.
Hope this helps.
Thanks,
JC
xSQL Software
http://www.xsqlsoftware.com|||It works. Thank both of you
"Adam Machanic" <amachanic@.IHATESPAMgmail.com>
':%23jF$gbPtHHA.2164@.TK2MSFTNGP02.phx.gbl...
> You can do it yourself if you link the servers, but it may take a good
> amount of work. Easier might be to use a third party tool. Red-Gate's
> SQL Data Compare is probably the most obvious choice...
> http://www.red-gate.com/products/SQ...mpare/index.htm
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "zlf" <zlfcn@.hotmail.com> wrote in message
> news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
>

Compare data difference between two database in SQLServer 2005

Hi,
I have too databases, their structures are completely same, with minor data
difference, I want to generate a patch SQL statements, not complete backup
by comparing them, thus I can synchronzie the out-dated database with that
script. Does SQLServer2005 provide thus functionality? Or there is other
tool I can use. Thank you
zlfYou can do it yourself if you link the servers, but it may take a good
amount of work. Easier might be to use a third party tool. Red-Gate's SQL
Data Compare is probably the most obvious choice...
http://www.red-gate.com/products/SQL_Data_Compare/index.htm
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"zlf" <zlfcn@.hotmail.com> wrote in message
news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have too databases, their structures are completely same, with minor
> data difference, I want to generate a patch SQL statements, not complete
> backup by comparing them, thus I can synchronzie the out-dated database
> with that script. Does SQLServer2005 provide thus functionality? Or there
> is other tool I can use. Thank you
> zlf
>|||On Jun 22, 1:57 pm, "Adam Machanic" <amacha...@.IHATESPAMgmail.com>
wrote:
> You can do it yourself if you link the servers, but it may take a good
> amount of work. Easier might be to use a third party tool. Red-Gate's SQL
> DataCompareis probably the most obvious choice...
> http://www.red-gate.com/products/SQL_Data_Compare/index.htm
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"http://www.apress.com/book/bookDisplay.html?bID=10220
> "zlf" <z...@.hotmail.com> wrote in message
> news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
>
> > Hi,
> > I have toodatabases, their structures are completely same, with minor
> > data difference, I want to generate a patch SQL statements, not complete
> > backup by comparing them, thus I can synchronzie the out-dated database
> > with that script. Does SQLServer2005 provide thus functionality? Or there
> > is other tool I can use. Thank you
> > zlf- Hide quoted text -
> - Show quoted text -
Hi Zif,
another great choice is xSQL Softwares xSQL Data Compare which you can
get from http://www.xsqlsoftware.com - you don't just get 2 weeks of
free trial but you also have it free forever for smaller size
databases (up to a certain number of objects) as well as free with no
limitations for SQL Server Express databases.
Furthermore, we have a well document api (xSQL SDK) that allows you to
integrate the functionality in your own application if you want.
Hope this helps.
Thanks,
JC
xSQL Software
http://www.xsqlsoftware.com|||It works. Thank both of you:)
"Adam Machanic" <amachanic@.IHATESPAMgmail.com>
':%23jF$gbPtHHA.2164@.TK2MSFTNGP02.phx.gbl...
> You can do it yourself if you link the servers, but it may take a good
> amount of work. Easier might be to use a third party tool. Red-Gate's
> SQL Data Compare is probably the most obvious choice...
> http://www.red-gate.com/products/SQL_Data_Compare/index.htm
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "zlf" <zlfcn@.hotmail.com> wrote in message
> news:uFrkmWPtHHA.1184@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I have too databases, their structures are completely same, with minor
>> data difference, I want to generate a patch SQL statements, not complete
>> backup by comparing them, thus I can synchronzie the out-dated database
>> with that script. Does SQLServer2005 provide thus functionality? Or there
>> is other tool I can use. Thank you
>> zlf
>

Communications between Datasets

Is there any way to put together data from multiple datasets into one in
order to generate a single report?
ThanksHi,
You can define multiple datasets into the same report definition in order to
put their data in the same report.
In the other hand, if you want to put data from different datasets in the
same table or list, you need to use subreports (See post tittled "Fields
from Multiple Datasets" into this news group.
Hope this helps,
Mónica
"markgoldin" <markgoldin_2000@.yahoo.com> escribió en el mensaje
news:364A7754-9D67-4F8A-8528-CEEE5A924C46@.microsoft.com...
> Is there any way to put together data from multiple datasets into one in
> order to generate a single report?
> Thanks|||On Dec 12, 6:23 am, "markgoldin" <markgoldin_2...@.yahoo.com> wrote:
> Is there any way to put together data from multiple datasets into one in
> order to generate a single report?
> Thanks
You may put all your data into text boxes from several datasets. You
can also use tables, but one dataset per table. So if you don't mind
having separate datasets on separate tables then go for it.

Common Generation Watermark error for Merge Replication

Hello,

We have a sqlexpress subscriber that is receiving the error below. SQL Server 2005

We have tried:

Generate new snapshot. Reinitialize the subscription. Dropped the subscription. Reboot the web server box. Reboot the sql server box.

Yet we still get the errors for these specific subscribers. Any ideas?

Error in replication monitor....

Error messages:

The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence. This could be due to the subscriber not having synchronized within the retention period, or because of one of the replicas being restored to a backup older than retention period, or because of the publisher performing more aggressive cleanup on articles of type download-only and articles with partition_options = 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199363)
Get help: http://help/MSSQL_REPL-2147199363

The common generation watermark is invalid at this replica since it does not exist or metadata for changes not yet propagated may have been cleaned up. (Source: MSSQLServer, Error number: 21800)
Get help: http://help/21800

Can you offer more details on how your merge topology is set up? How are the machines layed out and what version of SQL Server 2005 is on each, RTM or SP1? I am also interested in the publication, article, and subscription settings. Perhaps you could post the publication and subscription scripts. Any other info you can offer on repro steps would be helpful.

Thanks,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Did you manage to resolve this issue in the end? I'm getting the same error periodically here, so I'd be interested to know if you managed to get it fixed.

Cheers

Nick Hoggard

|||

The same problems occurs in my situation. 9 identical notebooks, each of them synchronizing using filters with SUSER_SNAME() rule. 2 of them stops with the same message. Have no idea what to do.

|||

Same problem here!

Some subscriptions fail with this error.
I really need a way to resolve this at the server as the subscribers are in the field.

Some more Info:
We have about 200 subscriptions and at the moment this problem appears at two of them.

At the client the error is 29006, which is not helping.

|||Unfortunately these issues are very very difficult to debug on a forum, I highly suggest opening a support case so you can have an engineer dig deeper into the problem.|||

Did anything ever get resolved for this? We are having same problem.

thx,

jg

|||Can you describe your problem scenario or the sequence of events that have led you to this failure please?|||I am receiving the same error. I have pretty much the same architecture in place. The error seems to center around the Upload changes first.|||Hi all,

found this one in Microsoft site.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=256575&wa=wsignin1.0

Thank you.
|||

Do these forums ever get checked? I experienced a similar problem, if not the same problem.

I have a publication that includes Views, SPs, and Functions only. The publication was running successfully on a SQL Express SP2 subscriber, but failed with the error message stated previously in this topic. I had to mark the subscriber as needing to reinitialize and then the publication got passed the error. No changes were made to the articles or publication to cause the error.

Thanks in advance,

Graham

|||

As mentioned above, please create a case with Customer Support so you cna have an engineer debug your issue, especially if this is blocking or hindering your production system.

Common Generation Watermark error for Merge Replication

Hello,

We have a sqlexpress subscriber that is receiving the error below. SQL Server 2005

We have tried:

Generate new snapshot. Reinitialize the subscription. Dropped the subscription. Reboot the web server box. Reboot the sql server box.

Yet we still get the errors for these specific subscribers. Any ideas?

Error in replication monitor....

Error messages:

The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence. This could be due to the subscriber not having synchronized within the retention period, or because of one of the replicas being restored to a backup older than retention period, or because of the publisher performing more aggressive cleanup on articles of type download-only and articles with partition_options = 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199363)
Get help: http://help/MSSQL_REPL-2147199363

The common generation watermark is invalid at this replica since it does not exist or metadata for changes not yet propagated may have been cleaned up. (Source: MSSQLServer, Error number: 21800)
Get help: http://help/21800

Can you offer more details on how your merge topology is set up? How are the machines layed out and what version of SQL Server 2005 is on each, RTM or SP1? I am also interested in the publication, article, and subscription settings. Perhaps you could post the publication and subscription scripts. Any other info you can offer on repro steps would be helpful.

Thanks,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Did you manage to resolve this issue in the end? I'm getting the same error periodically here, so I'd be interested to know if you managed to get it fixed.

Cheers

Nick Hoggard

|||

The same problems occurs in my situation. 9 identical notebooks, each of them synchronizing using filters with SUSER_SNAME() rule. 2 of them stops with the same message. Have no idea what to do.

|||

Same problem here!

Some subscriptions fail with this error.
I really need a way to resolve this at the server as the subscribers are in the field.

Some more Info:
We have about 200 subscriptions and at the moment this problem appears at two of them.

At the client the error is 29006, which is not helping.

|||Unfortunately these issues are very very difficult to debug on a forum, I highly suggest opening a support case so you can have an engineer dig deeper into the problem.|||

Did anything ever get resolved for this? We are having same problem.

thx,

jg

|||Can you describe your problem scenario or the sequence of events that have led you to this failure please?|||I am receiving the same error. I have pretty much the same architecture in place. The error seems to center around the Upload changes first.|||Hi all,

found this one in Microsoft site.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=256575&wa=wsignin1.0

Thank you.
|||

Do these forums ever get checked? I experienced a similar problem, if not the same problem.

I have a publication that includes Views, SPs, and Functions only. The publication was running successfully on a SQL Express SP2 subscriber, but failed with the error message stated previously in this topic. I had to mark the subscriber as needing to reinitialize and then the publication got passed the error. No changes were made to the articles or publication to cause the error.

Thanks in advance,

Graham

|||

As mentioned above, please create a case with Customer Support so you cna have an engineer debug your issue, especially if this is blocking or hindering your production system.

Common Generation Watermark error for Merge Replication

Hello,

We have a sqlexpress subscriber that is receiving the error below. SQL Server 2005

We have tried:

Generate new snapshot. Reinitialize the subscription. Dropped the subscription. Reboot the web server box. Reboot the sql server box.

Yet we still get the errors for these specific subscribers. Any ideas?

Error in replication monitor....

Error messages:

The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could be lost leading to non-convergence. This could be due to the subscriber not having synchronized within the retention period, or because of one of the replicas being restored to a backup older than retention period, or because of the publisher performing more aggressive cleanup on articles of type download-only and articles with partition_options = 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199363)
Get help: http://help/MSSQL_REPL-2147199363

The common generation watermark is invalid at this replica since it does not exist or metadata for changes not yet propagated may have been cleaned up. (Source: MSSQLServer, Error number: 21800)
Get help: http://help/21800

Can you offer more details on how your merge topology is set up? How are the machines layed out and what version of SQL Server 2005 is on each, RTM or SP1? I am also interested in the publication, article, and subscription settings. Perhaps you could post the publication and subscription scripts. Any other info you can offer on repro steps would be helpful.

Thanks,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

Did you manage to resolve this issue in the end? I'm getting the same error periodically here, so I'd be interested to know if you managed to get it fixed.

Cheers

Nick Hoggard

|||

The same problems occurs in my situation. 9 identical notebooks, each of them synchronizing using filters with SUSER_SNAME() rule. 2 of them stops with the same message. Have no idea what to do.

|||

Same problem here!

Some subscriptions fail with this error.
I really need a way to resolve this at the server as the subscribers are in the field.

Some more Info:
We have about 200 subscriptions and at the moment this problem appears at two of them.

At the client the error is 29006, which is not helping.

|||Unfortunately these issues are very very difficult to debug on a forum, I highly suggest opening a support case so you can have an engineer dig deeper into the problem.|||

Did anything ever get resolved for this? We are having same problem.

thx,

jg

|||Can you describe your problem scenario or the sequence of events that have led you to this failure please?|||I am receiving the same error. I have pretty much the same architecture in place. The error seems to center around the Upload changes first.|||Hi all,

found this one in Microsoft site.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=256575&wa=wsignin1.0

Thank you.
|||

Do these forums ever get checked? I experienced a similar problem, if not the same problem.

I have a publication that includes Views, SPs, and Functions only. The publication was running successfully on a SQL Express SP2 subscriber, but failed with the error message stated previously in this topic. I had to mark the subscriber as needing to reinitialize and then the publication got passed the error. No changes were made to the articles or publication to cause the error.

Thanks in advance,

Graham

|||

As mentioned above, please create a case with Customer Support so you cna have an engineer debug your issue, especially if this is blocking or hindering your production system.

Command line to pass parameters in SQL

Hi,
Do you know if any command I can use to pass parameters into reports,
generate PDF report format and drop it into a shared folder? Thanks.
ChuckYou can pass parameters ,and create PDF from a URL report request, but I do
not think you can specify a save directory
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Chuck" <Chuck@.discussions.microsoft.com> wrote in message
news:297FC292-95E4-408D-9E93-78C698A98AFC@.microsoft.com...
> Hi,
> Do you know if any command I can use to pass parameters into reports,
> generate PDF report format and drop it into a shared folder? Thanks.
>
> Chuck