There is a way using the Microsoft Enterprise Manager of SQL Server. The "DTS" (Data Transformation Service) offers a way to connect to odbc sources, extract the table structure of the source, generate "create Table" statements which you can edit for the destination and finally move the data. So one can move it's data and the table structure from one server to another. So far it wirked fine for me. However, of course it does not help in moving indexes, stored procedures, foreign keys, cascaded deletes, triggers, views etc. The Enterprise Manager is part of the MS-SQL Server. It can be installed separately. (Gerald)
> I had liek to import all the table structures including the > relations as in Access inbto my SAPDB database. i think there is no way, and it would be a good idea, indeed! but microsoft hasn't had it yet. i'm also doing some imports/linking sometimes, but everytime i import a table, it results in having text-columns instead of int-columns. what about your imported tables? _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
