Showing posts with label sqlserver2005. Show all posts
Showing posts with label sqlserver2005. Show all posts

Sunday, March 25, 2012

Converting an Access database

Converting an Access database

I uninstalled sqlserver2005 express and reinstalled sqlserver2005 ctp. Now, everything is in order.

I've just searched books online for convert(conversion) and import(imports, importing).

I see no instructions on how to convert my access 2003 database into an sqlserver database.

It was easy enough in sqlserver 2000. However, I've uninstalled that. Is there a way of coverting in sqlserver 2005? I'm in big trouble if I can't.

A related question. I'm very familiar with Access 2003. So I'll continue to develop the database structure in Access. Can I import the incremental changes? Or do I have to delete the current conversion and re-import(assuming I can) the whole new database each time?

dennist685

You can use the access upsizing wizard (tools-> database utilities ->upsizing wizard) from within access to push the data. Alternatively, use SSIS from SQL 2005 to import the data from access.

Cathal|||Cathal,

Thank you very much. I had no idea one could do it from Access.

dennist685|||Search as I could, I couldn't find SSIS in sqlserver 2005

Dennist685

Converting an Access database

Converting an Access database

I uninstalled sqlserver2005 express and reinstalled sqlserver2005 ctp. Now, everything is in order.

I've just searched books online for convert(conversion) and import(imports, importing).

I see no instructions on how to convert my access 2003 database into an sqlserver database.

It was easy enough in sqlserver 2000. However, I've uninstalled that. Is there a way of coverting in sqlserver 2005? I'm in big trouble if I can't.

A related question. I'm very familiar with Access 2003. So I'll continue to develop the database structure in Access. Can I import the incremental changes? Or do I have to delete the current conversion and re-import(assuming I can) the whole new database each time?

dennist685

You can use the access upsizing wizard (tools-> database utilities ->upsizing wizard) from within access to push the data. Alternatively, use SSIS from SQL 2005 to import the data from access.

Cathal|||Cathal,

Thank you very much. I had no idea one could do it from Access.

dennist685|||Search as I could, I couldn't find SSIS in sqlserver 2005

Dennist685

Thursday, March 8, 2012

convert SQLServer Expresss database to sqlserver2000

I have some question about SQLServer Expresss.

1. I want attach a SQLServer Expresss database to sqlserver2005.is it possible? How?

2. Can I get script by SQLServer Expresss?

3. And my important question is: How can I convert a SQLServer Expresss database to sqlserver2000?

Please help me.

Thanks in advance.

If both Express and the other edition are in the same network, register the Express to the full edition and use the Backup and Restore Wizard to Backup the database in Express then Restore in the full edition. You could try auto attach which may not work because regular attach require both MDF(Microsoft data file) and LDF(log data file). If you did not create the database with .SQL code or the GUI in Management Studio in Express then you may not have the LDF.

http://msdn2.microsoft.com/en-us/library/ms190631.aspx

Now to 2000 create a blank database in 2000 and then use DTS in 2000 to move your data and tables to 2000 because there are differences. I have posted a FAQ of how to move databases in the thread below. Hope this helps.

http://forums.asp.net/thread/1454694.aspx

|||

Hello

as you said I tried to Backup the database in Express but I couldn't Restore it in full edition .

I get this errore: Error 3205

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)

What's the problem? :(

Thanks for your helping

|||

The Backup and Restore wizard have nothing to do with .NET you are supposed to do it in Management Studio, so I have posted a FAQ which includes a Backup free chapter of a book use it. Hope this helps.

http://forums.asp.net/thread/1454694.aspx

convert SQLServer 2005 to SQLServer 2000

hello,
does anyone know a tool to convert a SQLServer2005 database to
SQLServer2k?
candide_sh
Hello,
As far as I know there is no toool to do that. Only possibility is by
installing SQL 2000 and use DTS / SSIS to copy objects and Data from SQL
2005.
Thanks
Hari
<candide_sh@.yahoo.de> wrote in message
news:1169726869.451045.129600@.a75g2000cwd.googlegr oups.com...
> hello,
> does anyone know a tool to convert a SQLServer2005 database to
> SQLServer2k?
> --
> candide_sh
>
|||hello,
I downloaded DB Publishing Wizard, had a little issue with one UNICODE
value, did a manual workaround and all is fine.
thanks
On 26 Jan., 07:25, Gerald Aichholzer <gerald.aichhol...@.gmx.net>
wrote:
> Hello,
> candide...@.yahoo.de wrote:
> <quote>
> SQL Server Database Publishing Wizard enables the deployment of SQL
> Server databases into a hosted environment on either a SQL Server 2000
> or 2005 server. It generates a single SQL script file which can be used
> to recreate a database (both schema and data) in a shared hosting
> environment where the only connectivity to a server is through a
> web-based control panel with a script execution window. If supported by
> the hosting service provider, the Database Publishing Wizard can also
> directly upload databases to servers located at the shared hosting provider.
> </quote>
> HTH,
> Gerald