Hello Every one
I need to find a way to Convert
a Complete MS Access  Database to MS SQL Server with the help of VB6 Code.
All the Tables/Queries/Stored Procedures/Views
Should be converted into Sql Server.
The Name of the Database should be the Same as of MS Access Database
regards
Ahmad

[Edited by ahmad on 29-03-2007 at 03:54 PM GMT]

[Edited by ahmad on 29-03-2007 at 04:45 PM GMT]

____________________________
@#@#@

Hello. It's not a simple topic. Mind it has been even written a book, and I got it on my bedside shelf, by the name "From Access to SQL Server" (author Russell Sinclair).

The principle is you can export all tables' structures, all queries and many other objects by the Microsoft Upsizing Wizard tool, but there are things that won't be exported, and many things will be changed during conversion so at the end you must check everything for misworking and this check requires as much work as creating a new db.

Furthermore, once you created the new SQL Server db, you can import data into it from many kind of sources, including mdbs. Only, tables' structures have to be the same in both import and source sides, and fields' datatypes have to be compatible - say, you can't import a text field into a decimal field, for instance. Unfortunately, even if you can easily create an empty SS db using an sql script, building this script is not easy and Access provides no tools to automate its creation.

And over all, you can't replicate VBA functions into SQL Server, as it doesn't provide any VB feature at all. I mean: no forms, no reports, no data pages, no modules, no macros, no native Access' VBA functions. You can build some stored procedure to execute some actions, but they can only be data actions. In the same way, SS triggers can't replace VBA events as they are raised only by changes on data, not by interface or Windows events.

Anyway I send you back to the book above, or similar, for more details.

Hope it helps.

____________________________
Real Programmer can count up to 1024 on his fingers