Using the Upsizing Wizard

[lkennemur]

Hello,

I am attempting to use the upsizing wizard under the tools menu. I need to move my database to a sql server. However, when I select use Existing Database and click next, my database isn't visible. All I can choose from in my folder is some zipped files. How can I get it to recognize a .mdb file?

Thanks,

Lesley

 

[stix4t2]

The question is where you are going to upsize to. You must either create and odbc dsn for an existing sql database or create a new db on the sql server. The db you are currently in will be the source.

 

[lkennemur]

Ok, I have never done this before and am not familiar with any of this. Could you spell it out for me or give me a link with step by step info?

 

[stix4t2]

I am not that familiar with this site to know all the threads. It sounds like you do not have an existing DB on your sql server for this application. This is what the question was asking you. After you do an initial upsizing, you may need to add extra tables to the SQL Server. Then you would use the existing database selection so to add the new tables to any previously created.

If this is the first upsize for the database, click on new database and follow the instructions.