sql server - Migrate SQL2000 Database to SQL2005 on another machine -

-

i've been beating myself on head app migration few days now. have old mssql server 2000-backed application being upgraded windows 2003 server running smsql server 2005. know little sql server not enough.

i tried backing database on old server going databases->[database]->all tasks->backup database..., selecting 'full', , saving file. moved backup file new server , tried restore complained saying looking [database].mdf file in location on old server.

so tried export data, selected local sql 2000 database, pointed new sql 2005 database on other machine, , gets way end , dies complaining way 1 of tables being joined.

i tried doing 'generate sql' command on 2000 box , running under sql 2005. looks there lot of outer joins using old *= syntax sql server 2005 doesn't support anymore and, being vendor database, have no idea true intentions when set these tables.

is there other way can try migrating database over?

the backup file has "hard" location of data files stored in it. need update them:

when restore in 2005, before click final "ok" restore (after have selected .bak file), go options tab. have mdf , ldf locations in backup file. change these legitimate directories on new machine.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more