1

hi.

i have a fogbugz 4 installation using access. i would like switch to sql server (2005, express) on the same machine instead. what i tried was the following:

  • installed fb again (same machine, but specifying sql server as db)
  • after installation was complete, i tried to use the sql server managment studio "import data" wizard to import the access data into the newly created fogbugz database.

however, this doesn't work: the tables created by the fb setup have different names than the ones that come from access.

i also tried to map tables in the import wizard, but that fails for other reasons. (looks like some column definitions are different.).

is it at all possible to change from access top sql server 2005?

WM_THX -thomas woelfer

flag

2 Answers

1

This should help: Access: Converting your Access Database to Another Format

link|flag
this is the same article the other person linked to. and no, it simply doesn't work this way as i explained in my last comment. – thomas woelfer Mar 12 2010 at 16:55
@thomas The link I posted is not the same link Greg posted. – Michael Pryor♦ Mar 15 2010 at 23:28
0

See this question: Access Upsizing Wizard: Beware

link|flag
no, this doesn't work. first, the data source cannot be "microsoft ole db provider for sql server", because the data source is an access file, and not ole db fpr sql server. (i tried this using 'access' as data source.) later in the wizard, when the data gets copied, the copy process will copy the data to tables named [dbo].[TableName], while fogbugz setup has created tables like [NameOfLocalServer].[dbo].[TableName]. so, after the import, there is absolutely no data in the tables that have been created by setup and when used, fogbugz doesn't see any data. – thomas woelfer Mar 5 2010 at 18:12

Your Answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.