on 10-19-2021 7:01 AM
I need to import 2500 tables into MS SQL server from three different db's that we receive from a client ,who db's are stored on advantage server .
Problem is , if there were few handful of tables , we could have used AdvantageData Architect and do few clicks and export the data to csv and then import into SQL Server .
Can someone please advise , how to accomplish this task for 1000's of tables/adt files .
there's nothing pre-built. Depending on the dev environment you use, you might query the list of all tables and then do the export/import table by table.
If you use a data dictionary, you can get all tables by
SELECT * FROM system.tables
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.