Sorry for the title but that's what I’m in.  I have done searches on Upsizing, access to mssql, acces to sql, access upgrade and none of them had a step by step on how to upsize to MSSQL!  So I got mssql loaded and I have version 7.6 working just fine with mssql.  I ran the config wizard and that created all the necessary tables inside of mssql database that I had created.  Now it's time to use the upsizing wizard!  I went to access then I went to tools - database utilities - upsizing wizard then this is where everyone drops off with a good description on what to do?  So I choose use existing database because I already created one through MSSQL as per previous posts!  At this point is where I got lost and I'm sure others have too!  So I decided to mess around to see the best way I could see to get the database over to SQL.  So at the File Data Source window I decided to click New then at the Create New Data Source I choose SQL Server.  Then I jut put in the sql server name the and the admin account for SQL so it would have full access to do the conversion.  I tested the connection and everything seemed wonderful? IS THIS STEP CORRECT THAT I DID?  Ok after this step I took the defaults to put the data from the access database over to the SQL one.  It went through but has some errors.  The only thing I could think of was that the tables were already created on my SQL database when I ran the msSQL_server_setup.asp.  And during the import it would not allow me to over write the existing tables?  Should I delete the tables in SQL then just import over all the access tables?  I’m not sure what to do at this point?  Are the steps I have done correct so far?  This upsizing procedure is alittle harder than I expected.  But then again I’m not a professional when it comes to development!!!!  Please help because I’m going to write a procedure out there for all the newbie’s so maybe I can help somebody else!

Thanks

Lo

The two tabs are File Data Source or Machine Data Source.  Should I create a new connection under Machine Datasource.  Once I pin this down then I will document a complete step by step procedure and send you the document and maybe you could put it on the site?  Or I can publish it on my site it's up to you  It get's confusing?  I'm wondering should I delete any tables in SQL because I'm importing the same tables from Access won't this kick up errors?  Or will this just integrate the data into SQL?

Thanks Again

Lo

One more thing is it possible to download the sql version of 7.5a because I still want to use my Invision Skin?  I can't find the 7.5a version any where to download.  Until someone fixes that skin I'm staying with ver 7.5a

Ok I'm done filling up this forum.  The access to sql problem is a big thing for me!  So if anyone can help please do

michael you sound like your on to something:)  I'mgoing to need some screen prints I'm by no means a database guru..  I tried to run the wizard on the enterprise manager and I selected my database but i wasn't sure what options to use so I signed in with the sql admin password and begun the import and I got 13 errors  six tables did import!  But when i go to the forum there is no data!  Here is a few screen prints

All the errors have the above explanation.

just give me a few prints and i will be on my way!  I heard sql is the way to go so I would love to have it as my database server.   And I have learned so much just administrating the software but of course there is so much more to learn!!!!! 

Thanks!!!

Lo

Ok i did try another thing!  I chose the upsize wizard and said to make a new database this created a new database on the sqlserver.  I can now attach to the database via the forum but am I getting the full functionalty of sql?  That would be the question.  With this method there is less stored procedure then creating a data base right from the 'msSQL_server_setup.asp'.  I went into the database created from scrath and there seemed to be more store procedures is this going to hinder the performance that I'm looking for?

Sorry for so many questions I'm just looking for the best method.  I would love to create an HTML page just for this procedure I think it really needs to be done!  Newbies like myself need help or even have our hand held throught the process.

Thanks again

Lo

And yes, I'm stuck here as well...part of the tables simply won't copy because of primary key issues etc.

Could someone explain how to use DTS correctly?

Dont create the database in SQL. Open your MDB file in access and run the upsizing wizard. Let it create your SQL database. Then run the mssql setup script in the forum. You will get a few errors that tables already exist but it will create the necessary stored procedures.

Then you should be good to go

That does the trick, + a restart here .

Thanks.

Hmm...that's weird..same issue here.

Did someone succeeded completely, and how?

I think it creates an admin account because it's a new install of the forum really?  I think it has something to do with the stored procedures?  But who knows I'm not a developer

As long as it works

Sure..

http://www.lodogg.com/upsizing.htm - http://www.lodogg.com/upsizing.htm

This what I did and it worked for me?

lodogg wrote: Sure.. http://www.lodogg.com/upsizing.htm - http://www.lodogg.com/upsizing.htm This what I did and it worked for me?

I followed the steps as described everything seems to go well exept the errors when running ms_sql_setup.asp but that is already known.

after I run the script I could see al the forum topics and categories but I couldnt see the messages posted in a forum. it gives all 0 I Re-sync Topic and Post Count in admin but gives the same. when I click on a topic from last forum posts I get the error that dont have permession to get in the forum??!!! I am login in as administrator...

You got me... I'm by know means a sql guru I wish I was:(  Those steps worked for me.  I would try different methods of importing and see if that works?  Are you using SQL 2000?

Thanks

Lo

I still getting the weired problem that all posts are created by forum administrator??!!!

if I use DST (import data from mssql) then I got errors because of duplicate keys etc...  is it possible to get a custimezed version of ms_sql_setup.asp for the import. I mean that the script only creates the db and the stored procedures and that the import tool creates the tables??!!!

please help and thanks in advance

That's clearly defined in the ms_sql_setup.asp file. You can delete the part that creates tables etc. It should eliminate the issue that it creates double values under the smut and configuration table, along with the double administrator name that is created.

Just comment out everything except for the creation of stored procedures..this will only work if you use the upsizing method from access.