Is it possible to get the description of a sql server table ?
-
Hello everybody, I'm working on a data migration application. Actually I need to map each fields in an existing database to a new application's databse. For this purpose, is it possible to list the fields in the tables (which will be an unknown thing until the program is run.. u'll have only the database name & the table names) of both the databases(both databases being sql server). I need to permit the user to map the fields like below.. Database1 Database2 OldTable NewTable firstname ------------> fname LastName ------------> lname etc... Thanks in advance
-
Hello everybody, I'm working on a data migration application. Actually I need to map each fields in an existing database to a new application's databse. For this purpose, is it possible to list the fields in the tables (which will be an unknown thing until the program is run.. u'll have only the database name & the table names) of both the databases(both databases being sql server). I need to permit the user to map the fields like below.. Database1 Database2 OldTable NewTable firstname ------------> fname LastName ------------> lname etc... Thanks in advance
-
Hello everybody, I'm working on a data migration application. Actually I need to map each fields in an existing database to a new application's databse. For this purpose, is it possible to list the fields in the tables (which will be an unknown thing until the program is run.. u'll have only the database name & the table names) of both the databases(both databases being sql server). I need to permit the user to map the fields like below.. Database1 Database2 OldTable NewTable firstname ------------> fname LastName ------------> lname etc... Thanks in advance
Erhm, yes this is possible, but I don't think you want to solve the problem this way. Have you tried converting the old db to the new db using DTS packages, it's a SQL Server thing and realy powerfull for converting data in such a manner..
.: I love it when a plan comes together :. http://www.zonderpunt.nl
-
Hello everybody, I'm working on a data migration application. Actually I need to map each fields in an existing database to a new application's databse. For this purpose, is it possible to list the fields in the tables (which will be an unknown thing until the program is run.. u'll have only the database name & the table names) of both the databases(both databases being sql server). I need to permit the user to map the fields like below.. Database1 Database2 OldTable NewTable firstname ------------> fname LastName ------------> lname etc... Thanks in advance