October 30, 2008 at 4:28 am
Hi
I want to do a similar aplication with ApexSqlDiff and I want to ask you if you know any open source aplication that looks like this, because I have some questions and that could be my inspiration.
I want mainly to compare two similar databases and in case there are diferences to generate some script si syncronize them.Mainly structure comparing, but if I do that ,data comparing won't be so hard.
If there aren't open source projects....I think I will stress you again with questions 😀
Thank you
October 30, 2008 at 4:58 am
Hello,
XSQL Software offer a free “Lite” version of their s/w bundle which includes schema and data comparison and synchronisation tools (http://www.xsqlsoftware.com/LiteEdition.aspx).
Okay it is not open source, but it is free.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
October 30, 2008 at 5:08 am
Thank you...but I'm interested the SQL "part" of the tool...I will think about the rest later.
For instance I want to know where can I find all the info about a table...to use it for the resulting script(columns,index,constraints ).Information_schema.* is usefull but I think is not enough for having a complete result... or maybe I'm not right....
October 30, 2008 at 5:41 am
Hello,
I’m not sure exactly what you want to do. If you want the script of a table and its indexes, constraints etc. then you can do that from SSMS. If you want to generate a script of differences between objects in two different DBs then you can use xSQL.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
October 30, 2008 at 6:11 am
one more command available in SQL 2005, TableDiff.exe, try this command, for more info. see SQL BOL.
October 30, 2008 at 7:43 am
You say that is possible from SSMS . Then I have a question.Is there a way to find the create statement of a table, the way you find for a sp with information_schema.routines, the routine_definition field?
If it is...please tell me!!!:)
because I don't think is a good idea to build the create statement for each table by searching in this views
Thank you again
October 30, 2008 at 8:03 am
Kishore.P (10/30/2008)
one more command available in SQL 2005, TableDiff.exe, try this command, for more info. see SQL BOL.
TableDiff compares data in tables with the same schema. If the schema is different it fails with an error. Check out this blog post which includes some thoughts on it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 31, 2008 at 2:19 am
...or how can I build the create index statement from views ....?is there a field view that contains this statement?
can anybody tell me?
thank you
October 31, 2008 at 4:14 am
Hello,
SSMS has Scripting tools available from the Menus. They give you the option to script the Create statements for one or many objects, depending on what context you are in.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
October 31, 2008 at 5:32 am
I know that, but I want to do this dynamic
I have a table...and I want to create it exactly the same...using t sql
to make a script for creating the table,the constraints,the indexes....
I searched into the views but I find smth only for sp and views,not for the rest...
I don't know if this is that easy....
.thank again for your answers
October 31, 2008 at 9:09 am
You can either start looking at SMO for ways to do this, or start researching the system views. Some of the tables are sys.tables, sys.columns. Start with these and BOL, and you should be able to identify the additional views you will need.
October 31, 2008 at 9:18 am
I know this ones:D
The idea is that I don't think I can build an identical create statement for a table,or for an index, but the programers that build ApexSqlDiff did. That means there is a posibility, or the statement is sored somewhere.
For instance for indexes I found the type of index and the table,but I can't find the column(s) where he is aplied....
I'm sure there must be a way 🙂 and I'm not finding it
That's why I need your help.
Thank you
October 31, 2008 at 9:27 am
I'm going to point you right back to BOL. I have written a few scripts to build some tables based on other tables and everything I needed to know I found in BOL. This includes identifying indexes, the columns used, the order of the columns, if the columns were in ascending or descending order, if the index was unique or not, clustered or nonclustered. Even could determine if it was based on a contraint (PK) or not.
October 31, 2008 at 10:15 am
and if i have an index on 2 columns....
I can't find this anywhere...
I will come with other examples ...later,because now I need a break
I believe you and I will start searching again....
but if you remember anything 😀 ;;) it will be very usefull for me...
October 31, 2008 at 10:34 am
shnex (10/31/2008)
and if i have an index on 2 columns....I can't find this anywhere...
I will come with other examples ...later,because now I need a break
I believe you and I will start searching again....
but if you remember anything 😀 ;;) it will be very usefull for me...
sys.index_columns -- Contains one row per column that is part of a sys.indexes index or unordered table (heap).
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply