Export ms sql server 2005 to .sql
-
Does anyone know how to transfer an entire database out of mssql server 2005 (express) into a .sql file so I can recreate it? I have looked though the TSQL commands on msdn and tried bcp (unless I'm missing somthing that will only do tables and I need the stored procedures as well) The reason for this is I want to export the data and put it into a ms sql 2000 database but dts won't work because the database is so different (neither will the sp_attach_db stored procedure (gives an error about indexes)
-
Does anyone know how to transfer an entire database out of mssql server 2005 (express) into a .sql file so I can recreate it? I have looked though the TSQL commands on msdn and tried bcp (unless I'm missing somthing that will only do tables and I need the stored procedures as well) The reason for this is I want to export the data and put it into a ms sql 2000 database but dts won't work because the database is so different (neither will the sp_attach_db stored procedure (gives an error about indexes)
I've not had a chance to play around with SQL Server 2005, but in SQL Server 2000 the Enterprise Manager has a feature where you can script database objects (tables, views, stored procedures, user defined functions, etc.) by right clicking on them and selecting the Script item. You can also click on the database to script the whole DB. I'm guessing that SQL Server 2005 will have something similar.
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
I've not had a chance to play around with SQL Server 2005, but in SQL Server 2000 the Enterprise Manager has a feature where you can script database objects (tables, views, stored procedures, user defined functions, etc.) by right clicking on them and selecting the Script item. You can also click on the database to script the whole DB. I'm guessing that SQL Server 2005 will have something similar.
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
that's the problem ;) the express version of 2005 doesn't have enterprise manager, it has a community built one that doesn't have much funtionality right now. The higher versions of 2005 are suppose to have this but not express (express is the msde of 2005)
-
that's the problem ;) the express version of 2005 doesn't have enterprise manager, it has a community built one that doesn't have much funtionality right now. The higher versions of 2005 are suppose to have this but not express (express is the msde of 2005)
djkno3 wrote: the express version of 2005 doesn't have enterprise manager Curious - I was at a Microsoft conference earlier this week and MS were saying that the only difference between the versions was the scaleability. IIRC, Express was supposed to have everything but is limited to operating on single processor with a maximum DB size of 4GB.
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
djkno3 wrote: the express version of 2005 doesn't have enterprise manager Curious - I was at a Microsoft conference earlier this week and MS were saying that the only difference between the versions was the scaleability. IIRC, Express was supposed to have everything but is limited to operating on single processor with a maximum DB size of 4GB.
My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
-
it has all the *funtionality* but not the tools ;) (oh and 1 gig ram usage is the other limitation)
SQL Express Manager is supposed to have this capability. Download from here[^]. Note that the version of Express Manager needs to match the version of SQL Server Express, so you'll need to upgrade your database server to the April CTP to match the currently-available Express Manager CTP. Stability. What an interesting concept. -- Chris Maunder
-
SQL Express Manager is supposed to have this capability. Download from here[^]. Note that the version of Express Manager needs to match the version of SQL Server Express, so you'll need to upgrade your database server to the April CTP to match the currently-available Express Manager CTP. Stability. What an interesting concept. -- Chris Maunder