Creating a SQL Script from ACCESS Database structure?

[Teerbaby]

Hi,

I tried to use the Upsizing-Wizard of ACCESS 2000 to upsize my databse for SQL Server 7. Unforunatly the Upsizing-Wizard had some Problems with some indexes, column names, etc.

Now, I thought of taking the database structure from the ACCESS database and creating a SQL script.

But before I try this I wanted to ask someone, if there is an easier way, or if somebody knows a tool do to that fixes that problem.

[Dillinger4]

I used to know alot about access and SQL but JAVA has consumed most of my time recently. But i think you would get a better response if you post in the database forum

But anyway....... To upsize a datbase to
a fully functional SQL server 7, dont you have to be connected to SQL server or have the MSDE (Microsoft Data Engine) installed and running?

[Teerbaby]

Originally posted by Dilenger4
I used to know alot about access and SQL but JAVA has consumed most of my time recently. But i think you would get a better response if you post in the database forum

But anyway....... To upsize a datbase to
a fully functional SQL server 7, dont you have to be connected to SQL server or have the MSDE (Microsoft Data Engine) installed and running?

Of course, the SQL Server / MSDE have to be running, but the Upsizing-Wizard of ACCESS just isn't able to deal with certain features of the database structure (certain properties, column names, etc.)

Especially, the indexes are a problem. That's what the Online-Doc says about it http://msdn.microsoft.com/library/en...asp?frame=true