Brian Swan

[QUOTE=faizabest;1288227]how can I transfer my SQl databese (located on PHPADMIN) to sql server?[/QUOTE] You could try using the SQL Server Migration Assistant for MySQL. If you want to migrate to a SQL Server 2005, the download is here: [url]http://www.microsoft.com/downloads/details.aspx?FamilyID=c6f14640-da22-4604-aaaa-a45de4a0cd4a&displaylang=en[/url] If you want to migrate to SQL Server 2008, the download …

What is the query you are using to pull data from the database? (Are you already using the UNIQUE clause?) -Brian

What error do you get when you execute your code? (That would help in figuring out the problem.) -Brian

This is by no means a complete answer (that will depend on your exact scenario), but it should get you started: [CODE]CREATE TABLE [dbo].[Table_2]( [Num1] [decimal](18,9) , [Num2] [decimal](18,9) , [Quotient] AS CAST(Num1/Num2 AS [decimal](18,9)) )[/CODE] This should allow you to do this: [CODE]insert into Table_2 (Num1, Num2) values (1,2)[/CODE] …

Maybe I don't understand the scenario completely, but if the database is small, I think you could just backup the first database and restore it in a new location. This would preserve any relationships automatically. These links might be helpful in understanding BACKUP and RESTORE: [url]http://msdn.microsoft.com/en-us/library/ms186865.aspx[/url] [url]http://msdn.microsoft.com/en-us/library/ms186858.aspx[/url] Hope that helps. …

I don't think there is any way to directly access the .mdf file with PHP...I think you need to attach it to a database server. You can download SQL Server Express for free: 2005 edition: [url]http://www.microsoft.com/downloads/details.aspx?FamilyID=220549B5-0B07-4448-8848-DCC397514B41&displaylang=en[/url] 2008 edition: [url]http://www.microsoft.com/express/Database/[/url] You'll also want to download the tools (Sql Server Management Studio …