473,287 Members | 1,419 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

migration sql2005 into sql2000

i make a project in vs2005 that use ASPNETDB.MDF
and use <asp:LoginView ID="LoginView1" runat="server" > server control for
vs2005

in this case , i'd like to use hosting service but this hosting company does
not support sql2005
that's why i have to use sql2000
so my quetion is how can i migration this for sql2000??
May 16 '06 #1
2 1664
If there is no pre-filled data, then use SQL 2005 Management studio to
generate SQL script for creating the table and then simply run that script
on SQL2000. If there is some data involved, then after the first step of
creating the DB in SQL2000, use Data Export to export data into SQL 2000.

"PointMan" <so**********@gmail.com> wrote in message
news:u8**************@TK2MSFTNGP04.phx.gbl...
i make a project in vs2005 that use ASPNETDB.MDF
and use <asp:LoginView ID="LoginView1" runat="server" > server control
for vs2005

in this case , i'd like to use hosting service but this hosting company
does not support sql2005
that's why i have to use sql2000
so my quetion is how can i migration this for sql2000??

May 16 '06 #2
http://weblogs.asp.net/scottgu/archi...25/423703.aspx

Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"PointMan" <so**********@gmail.com> wrote in message news:u8**************@TK2MSFTNGP04.phx.gbl...
i make a project in vs2005 that use ASPNETDB.MDF
and use <asp:LoginView ID="LoginView1" runat="server" > server control for vs2005

in this case , i'd like to use hosting service but this hosting company does not support sql2005
that's why i have to use sql2000
so my quetion is how can i migration this for sql2000??

May 16 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: LizP | last post by:
Hi, guys - looking for a bit of help/advice on moving a database from SQL 7 to SQL 2000. We've a third party application which currently uses a SQL7 database. This database has a number of views...
8
by: clintonG | last post by:
Membership is broken and who knows what else. Does anybody have any referrals to current documents that explain what was changed and how one might respond? <%= Clinton Gallagher...
1
by: Benny Ng | last post by:
The error is shown by the following connection string.£¨But it can be runs properly in SQL2000£© PROVIDER=MSDATASHAPE;DRIVER={SQL SERVER};SERVER=ibmdept;DATABASE=CY_20060208;UID=sa;PWD=111111; ...
5
by: Mike | last post by:
I'm having trouble accessing SQL2005 Standard Edition as a second instance of SQL Server where the first instance is SQL 2000 Enterprise Edition. I installed SQL 2005 as a named instance...
8
by: Radu | last post by:
Hi. This code worked fine with SQL2005, but has a problem with SQL2000.... Which one ???? cnSQL = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString"))...
2
by: itfetish | last post by:
I've just upgraded our WIndows 2003 (with SBS server) web server to .Net framework 2.0 (it had 1.1 before) As I have been working on a web parts page on my laptop, hosting it there, working...
0
by: ckmoied | last post by:
Hi guys, I want to know if there is any checklist available that one can follow before moving the databases from one server to another one. I am a newbie in SQL stuff and facing the following...
3
by: Tawfiq | last post by:
Hi, We have shifted one of our data processing to a new instance of SQL 2005. For this a new DB was created in SQL2005 and it is not an upgrade of SQL200 DB. The data processing application...
0
by: nic829 | last post by:
Hi, I was upgrading a instance from SQL2000 to SQL2005. During SQL2005 setup I accidently allow the files to be installed in C drive, but I should have them all installed in D drive. My databases...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.